Combining 2 or more csv files when only one csv contains headers and other csv files do not

1

I would like to use Easymorph to combine 2 or more csv files when only of the csv files contain just header data and the other csv files contain no headers but just data matching the same number of columns in the headers.csv file. I am already successfully using Easymorph to combine csv data files that share in common header fields. However, I would also like to do something like this below.
Note: while the example below contains an id field with numeric data values in file1 where the goal is to start with the File1 and combine it's header with the data from File2 and File3 in order of the ids, I would like it to combine in order that way regardless if there is an id field or not when seeking the workflow of Add New Action -> importing multiple files -> import delimited text file and selecting them in top to bottom order.'

What can be done to make this possible?

File1.csv
id,first_name,last_name

File2.csv
1,Susie,Drewery
2,Virgilio,Nelligan
3,Carolina,Ferrer

File3.csv
4,Susie,Drewery
5,Virgilio,Nelligan
6,Carolina,Ferrer

2

I would do it with a standard DOS-command:
C:>copy File*.csv all_files.csv

3

You can use the "Import plain text" action to read the text as is without parsing, and then the "Export plain text" action in the "Append" mode to append all texts into one file.

4

I went through this step and didn't see an "Append" mode. Curiously to know where that is found on v5.5.0.7 which is the latest version as of today. However, it still worked but it does combine based on the sequential naming convention of the files be combined. I've been doing this using the "cat" command line using batch files in windows with cmder for a good while and recently it stopped combining. Good to see EasyMorph provides a good reliable backup when prepping the files.

1 Like
5

Thank you for your response. I had been done cat command (cat file1.csv file2.csv > all_files.csv a really simple example - real files have 20 header files and different size rows) under windows to combine specific header files with their respective data also tried copy *.csv all_files.csv with unique files in selective subfolders and noticed recently this extra line with a square character appearing as the last line. While I can remove this 8th unwanted line with the sed command sed -i '8,1d' all_files.csv Each file processed with this issue can vary in number of lines so I used sed -i '$d' all_files.csv. It's quicker but for years cat worked with no issue then stopped combining resulting in zero length combined files. I trust EasyMorph's visual approach for building a workflow since ultimately there is also additional parsing to be done after different files get combined.

all_files.csv (140 Bytes)