I am reading a series of .txt files from a directory. There are two separate file layouts which need to be applied, so I filter first to segregate. Then, using the dynamic input, I use one of the files as the template for the data to read in all the matching data files. I want to have the original filename as part of the output file downstream. When I use the Dynamic Input, I'm losing that field. Is there a way to capture the name and have it on each row of data from the source file?
Solved! Go to Solution.
When editing the "Input Data Source Template" in the Dynamic Input tool configuration, use the "Output File Name as Field" setting under "Options":
Solved! Thanks so much