Hacker News Reader

Comment by MiracleUser | Hacker News Reader

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

View on HN

This 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:)

Reply on news.ycombinator.com