Can my dynamic input tool bring in a field from previous tool?

wonka1234

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?

Custom Tools

Accepted answers

gabrielvilella

You can enable the option to output the File Name or Full Path within the Dynamic Input, where you configure the template.

All comments

gabrielvilella

You can enable the option to output the File Name or Full Path within the Dynamic Input, where you configure the template.

wonka1234

This is my data before my dynamic input tool:

How do bring in Rec_202208 to correspond with the 202208 data.

nduan

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.

Community File Name and File Path.PNG

Let us know if that works!

gabrielvilella

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.

wonka1234

@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.

DataNath

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703