Keep Filepath as a Field with Dynamic Input

Hello,

I am using the Directory Tool to select ~50 files from a network folder. I then select the name of the file and the Creation Date of each file since I want to use this as a timestamp field. When I then extract all the records within each file, I do not see an option for me to bring the Creation Date through as it's own column. What am I missing?

Datasets

Accepted answers

HomesickSurfer

Hi @kristinaheuer

You can accomplish your requirement by using a Find Replace tool after your Dynamic Input to append the CreationTime (or modified to Creation Date.

Workflow package with sample files attached. Extract to C:\temp to demo

Dynamic Input with Creation Date.yxzp

atcodedog05

Hi @kristinaheuer

You need to first follow my solution of setting output full path config in dynamic input tool as step-1. Click on edit you will get the below window refer below.

Once you do that you will be able to follow @HomesickSurfer solution as step-2 to map the data.

Hope this helps : )

All comments

atcodedog05

Hi @kristinaheuer

Dynamic input also has an option to output full path as output. That would be your best choice. Refere below highlighted config.

Hope this helps : )

HomesickSurfer

Hi @kristinaheuer

You can accomplish your requirement by using a Find Replace tool after your Dynamic Input to append the CreationTime (or modified to Creation Date.

Workflow package with sample files attached. Extract to C:\temp to demo

Dynamic Input with Creation Date.yxzp

kristinaheuer

@HomesickSurfer - your description makes perfect sense. I believe I followed your steps completely but the fields are not coming through. Can you take a look at my flow and let me know what I am missing?

Filepath Append.yxzp

atcodedog05

Hi @kristinaheuer

You need to first follow my solution of setting output full path config in dynamic input tool as step-1. Click on edit you will get the below window refer below.

Once you do that you will be able to follow @HomesickSurfer solution as step-2 to map the data.

Hope this helps : )

kristinaheuer

I totally missed that!!!! Thank you so much, both of you. 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703