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
Solved! Go to Solution.
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
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