Combining multiple files (csv) and adding a appending a substring from filename

[LeoS]

Hi, everyone!

I am looking for combining multiple csv and adding a piece of the file name to the data.

See the below screenshot. I know how to combine files, but how do I add the substring after "_"? 

All files have the same shape; I want to add the substring to each corresponding data set for further analysis once I have everything consolidated.

Thank you!

[ImadZidan · Accepted solution]

Hello @LeoS ,

Can you use the output filename option. Will that not do the job.

You can then add a formula to change the name of the file and add the substring.

[LeoS]

Thank you!