Load the datasets into VisiData.
vd d1.tsv d2.tsv
o and enter a filepath for each file.
S to open the Sheets sheet.
t to select the sheets to merge.
gC to open a Columns sheet with all of the columns from selected sheets.
g! on the rows that reference the indices on which the join will be performed. At least one key column, per sheet, should be set.
S to return to the Sheets sheet.
Optional: If performing a left outer join, use
K to reorder the sheets. The first sheet will be the one for whom all rows will be retained.
& followed by the jointype to execute the join
||keeps only rows which match keys on all sheets|
||keeps all rows from first selected sheet|
||keeps all rows from all sheets (union)|
||keeps only rows NOT in all sheets|
||keeps all rows and retain SheetType from first selected sheet|
Sto open the Sheets sheet.
tto select the sheets to merge.
appendto concatenate the selected datasets.