We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

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

wonka1234
9 - Comet

 

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?

 

wonka1234_2-1668615191942.png

 

7 REPLIES 7
gabrielvilella
14 - Magnetar

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

gabrielvilella_0-1668615496024.png

 

wonka1234
9 - Comet

This is my data before my dynamic input tool:

 

wonka1234_0-1668615638557.png

 

 

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

nduan
Alteryx
Alteryx

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
14 - Magnetar

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.

gabrielvilella_0-1668615818615.png

 

wonka1234
9 - Comet

@nduan  the problem with this is that it doubles my record count.

 

Ie my target has 2569 records and my source has 2 records

 

wonka1234_0-1668616409993.png

wonka1234_1-1668616452490.png

 

 

sigh not sure how to map the dates to the correct read in records.

nduan
Alteryx
Alteryx

Can you try a find and replace and append the file name?

 

nduan_0-1668616690337.png

 

nduan_0-1668616806273.png

 

 

DataNath
16 - Nebula

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.

Labels