Hi,
I use my dyanmic tool to read a bunch of files in using my "fullpath" field..
But in my prior tool I also have filename, can I bring that in addition to append to my dataset?
So i read in fullpath to get the data, but i want to bring in file name as a field. Is that possible?
Solved! Go to Solution.
You can enable the option to output the File Name or Full Path within the Dynamic Input, where you configure the template.
This is my data before my dynamic input tool:
How do bring in Rec_202208 to correspond with the 202208 data.
You can append the file name from your other tool by adding a summarize (group by file name) to get one record with the file name and then use the append tool to append it to the rest of your data.
Let us know if that works!
Please follow the instruction I gave you. Go to Edit the template within the Dynamic Input (image below) and enable the Full Path or File Name as you see on the image above.
@nduan the problem with this is that it doubles my record count.
Ie my target has 2569 records and my source has 2 records
sigh not sure how to map the dates to the correct read in records.
Can you try a find and replace and append the file name?
Summarizing and appending/Find and Replacing the filename is massively convoluting this process - you can just do what @gabrielvilella has mentioned (twice) and tick a single box to carry the FileName through to the output of your Dynamic Input.