How to join two datasets
Open the datasets in VisiData.
vd d1.tsv d2.tsv
oand enter a filepath for each file.
Sto open up the Sheets Sheet. Through here, you can navigate to every sheet by pressing
Enteron the row it is referenced in.
- Navigate to the sheets you want the join, and set their shared columns as key columns with
Sto return to the Sheets sheet. Select the sheets you want to merge with
- Optional: If performing a left outer join, use
Shift+Kto reorder the sheets. The first sheet will be the one for whom all rows will be retained.
&to open the join-chooser, and select your desired jointype with
||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|
||Merges differences from other sheets into first sheet|
How to append two datasets
- Open the datasets with VisiData.
Shift+Sto open the Sheets sheet.
tto select the sheets to merge.
appendto concatenate the selected datasets.