Multiple csv to one csv

jaydeb91 · June 18, 2018, 2:27pm

I have multiple csv with same column files. I Want to make a one csv.

Please help how I accomplish

ScottF · June 18, 2018, 7:50pm

You can use a series of Concatenate nodes to combine your data, and then a CSV Writer node to write out a single file.

s.roughley · June 18, 2018, 9:55pm

Or if you have lots of the, use a List Files node to list them all, then a Table Row to Variable Loop Start node, then File Reader, taking the URL from the ‘URL’ flow variable from the loop start, and finally a Loop End node which will do the concatenation.

Steve

jaydeb91 · June 19, 2018, 4:48am

Thank you very much Sir…

jaydeb91 · June 19, 2018, 5:22am

It’s working checked it…

Thanks Sir for your help

jaydeb91 · June 19, 2018, 5:27am

jaydeb91 · August 2, 2019, 3:31am

s.roughley, ScottF I have 3 csv file, same column name in each csv file & value is different but when used attached not only value coming from file no 1. Concatenation not happening for all 3 files. Please help me.

KNIME_MULTIPLE.knwf (5.9 KB)

armingrudd · August 2, 2019, 3:50am

Hi,

The File Reader node in you workflow is reading the same file in each loop since you do not have assigned the “URL” flow variable to the file location option:

system · August 9, 2019, 3:50am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.