6 ms·
I tried vertical merge with 2 files that were each a single column of items (no header). The resulting file was 3 columns wide, 1 file in first column with sec
by MiracleUser 7y ago
I tried vertical merge with 2 files that were each a single column of items (no header). The resulting file was 3 columns wide, 1 file in first column with second and third columns blank and then below that the items from the second file were in the 3rd column with columns 1 and 2 blank
I was expecting a 1 column result file with both files items stacked
- jampoole 7y agoThis is expected as merging currently requires a header row for each file so that it can automatically line up the data accurately. For example if you had two csv files... [File1.csv] Id,ProductId 1,200 2,300 [File2.csv] ProductId,Name,Id 400,NameFor400,3 500,NameFor500,4 Final output would be... [Output.csv] Id,ProductId,Name 1,200,"" 2,300,"" 3,400,NameFor400 4,500,NameFor500 With that said, thanks for commenting! I will add an option for "No Header" files, or maybe even auto detect for these situations and do a straight merge:)