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!
Solved! Go to 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.
Thank you!