I'm trying to pull records from multiple files using directory tool and dynamic input tool.
I want a column that specifies from which file the record came.
Can anyone help.
Required format is shown below.
ID COLUMN
1 file1
2 file1
3 file1
4 file2
5 file3
Solved! Go to Solution.
There a configuration option in the dynamic Input tool where you can select filename as column name.
Thanks, Joseph. 🙂
Have a good day