Directory input .CSV with Dynamic input tool, how can I get the filename to transfer

[Bigmonki]

Hi,

Using the Directory tool I can input all my .CSV files at once, I have used the wildcard to filter the files I want and then linked them to a Dynamic input tool using the FIELD FullPath and the Action Change Entire File Path.

Here is where I have a challenge, the output from the Dynamic tool isn't including the filename or full path which I need for identifying which country the data comes from. If I choose any Action other than Change Entire File Path, I get an error when I run it?

The output data from the Dynamic tool is perfect, so a macro seems unnecessary work, but is that the way to get the filename or is there a simpler solution?

[JosephSerpis · Accepted solution]

Hi @Bigmonki have you gone into edit and selected Output File name as field in the dynamic Input tool configuration?

[Hamder83]

Hi 

what about using a directory and a simple input macro? 

Like this?

[Bigmonki]

@JosephSerpis 

Doh! School boy error!!! Thanks for that, I'll go write 100 lines "I must not forget the basics"

🙂