Alteryx Designer Desktop Discussions

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

Appending Info from Directory Tool To Data Output

JenniferO
8 - Asteroid

Hello Everyone!

 

I am using the Directory Tool in combination with the Filter Tool to go out to a file location and get all the files for the last two weeks.  They all have matching schemas.  Then, I'm using the Dynamic Input Tool to extract all the data from those files.  I would like to somehow append some of the info from the Directory Tool, such as the Full Path, FileName, CreationTime, to the data output so that my end user can quickly know which file the data came from and where to find it.  Any ideas?

 

Thank you!

 

Jennifer

 

 

2 REPLIES 2
JenniferO
8 - Asteroid

Hello - me again...

 

I figured it out.  Lol.  

 

For those who are interested, in the Dynamic Input (and regular Input) tool, you can select to have either the file name or full path be output as a field into the data set.  I was then able to use that to join back to the data set produced by the Directory Tool.  

 

So fun!

 

Thanks for participating in my madness.  

 

-Jennifer

Sushrut
5 - Atom

Hi Jennifer, Hope you are well.

 

Could you please tell which option to select as I'm unable to add the full path and file name to the imported files.

 

Edit: Never mind, found the option to add it. Thanks :) 

Thanks 

Sushrut

Labels