How To Combine Multiple Text Files

[CarishmaM]

I have about 10-15 txt files that I would like to combine and then implement the column delimiter which is a comma and then a row delimiter which seems to be a /.

I tried using CSV reader for 1 file, but it wouldn’t read it.

I tried using the list files node connecting to the table row to variable loop start and then connecting it to file reader. However, I cannot seem to figure out how to configure file reader.

[mlauber71]

@CarishmaM you will have to close the loop

Workflow Control: DB queries plus concatenate

Maybe this example with try and catch can serve as an inspiration Or you might want to check out the “switch” section of this collection You might want to create an example maybe with KNIME’s local big data environment to test what you are trying to do and for the forum to help.

And also you could check out some example how to import text files

Import CSV - This workflow will act as a meta workflow trying to answer...

[mlauber71]

Ah wanted to add this link, more about loops

Custom table list to be migrated to other database (mysql to postgres)

You could create or import a table as a meta table and use a loop to make the task. I collected a few maybe helpful links about that. If you have large or complicated operations you might want to include a check if your transfer was successful. KNIME course about loops https://www.knime.com/self-paced-course/l2-dw-knime-analytics-platform-for-data-wranglers-advanced/lesson4 @armingrudd articles about loops and flow variables Nodeguide to loop examples Special loop example involving dat…