How to take the full path name from the control parameter in a batch macro?

I need help connecting the dots. How can I take the full path (input from directory tool) from my control parameter in my batch macro and make it a field in the finished output? In other words, I need the full path to be a new field in the TDE extract for each processed TXT file.

Workflow:

Batch macro:

My idea is that on subsequent runs of this workflow, I can join on the new full path field and use the left join as a filter to find new files. The new files will be processed and appended to the extract. I think it will work but am I making this more complicated than it needs to be? Either way, I'd like to know how to bring the Metadata into a workflow.

Preparation

Accepted answers

vishwa_0308

in input data configuration you can find a selection to select the full path as "output file name as field". this will add a new field either with filename or full path.

All comments

vishwa_0308

in input data configuration you can find a selection to select the full path as "output file name as field". this will add a new field either with filename or full path.

smoskowitz

In the configuration of the input tool, look for the following option:

ddiesel

I was having trouble with this one because the text file has to come in with no delimiters due to the file format. Choosing full path with that option only provides the Name, Type, Size, Source and Description but no data. To solve this problem, I now have two action tools coming off the control parameter --- one with file path and one without. I join the data before macro output to make the full path a field in the finish output.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703