WHERE `file1.Student ID` = `file2.Student ID` SELECT `Student ID`, `Student Name`, `City`, `Subjects` $ join -1 1 -2 1 -t, -o 1.1,1.2,1.3,2.3 file1.csv file2.csvīy way of explanation, this join command written as SQL would be something like: We can do this using the following command: We want to do an equality join on the Student ID field (or we could use Student Name, it doesn't matter since both are common to each). If so, the Linux join command is a good fit for a problem like this. =IF(ISERROR(VLOOKUP(Foglio1!A1,Foglio2!$A$1:$B$3,2,0))=TRUE,"",VLOOKUP(Foglio1!A1,Foglio2!$A$1:$B$3,2,0))ĭue to your requirement to do this with "Linux commands" I assume that you have two CSV files rather than XLSX files. You can even solve with a simple formula.Ĭopy the content of Foglio1 in Foglio3, then run this formula LastUsedRowSh2 = Sheets(2).Cells(, "A").End(xlUp).Rowįor Each cell In Sheets(1).Range("a1:a" & lastUsedRowSh1) LastUsedRowSh1 = Sheets(1).Cells(, "A").End(xlUp).Row Sheets(3).Columns(2).Insert Shift:=xlToRight Dim i As Long, lastUsedRowSh1 As Long, lastUsedRowSh2 As Long
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |