Multiple csv to one csv

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

Please help how I accomplish

Hi @jaydeb91 -

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

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

2 Likes

Thank you very much Sir…

1 Like

It’s working checked it…

Thanks Sir for your help

4 Likes

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)

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:

:blush:

5 Likes

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