Help needed with loop

[Sander_vdv]

Good morning,

I have troubles figuring out using a loop. I have a folder with 20+ files, all with the same structure, and the same titel-structure. My goal is to concatenate all these files, but first include parts of the title as seperate columns. So I need to read file1, add columns with values from the title, read file2, add columns, concatenate the files etc.

Can anyone give me a hint how to start this flow?

Thanks!

Sander

[Gavin_Attard]

Can you provide sample data and example of outcomes?

[ipazin]

Hello @Sander_vdv,

just to add info that there are reader nodes that don’t require loop as they have option to read multiple files from same folder. But to see if it could be used in your case check @Gavin_Attard question

Br,
Ivan

[mlauber71]

This sounds like the questions we have discussed here:

Add column with fixed value from title of Excel file

You could look at this example:

Maybe you check that out or you could provide us a sample workflow that shows us your problem like @Gavin_Attard has already suggested.

[HansS]

Hi @Sander_vdv

In this workflow filename_in_columnname.knwf (42.2 KB)

multiple files are read in. A part of the file name is used to add to the column name.

Does this help?

gr. Hans