Want to add File name as a new column

[gautamgandhi98]

Hi Community,

I am using Directory and dynamic input to import all excel files in a particular folder and I want to add a new column in the final output and that new column should be the file name from which the data is coming. I want to do this dynamically as the number of files will increase in future.

[alexnajm]

Turn on this setting when you are setting up your template in the Dynamic Input tool!

[binuacs · Accepted solution]

@gautamgandhi98 

[gautamgandhi98]

Hi, Thanks a lot. I was trying this from last 6-7 hours