In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to add a column with date in dinamic input?

Joker_Hazard
11 - Bolide

Hello guys!

I have to a directory tool that reads all files in a folder. Each new file is updated daily and does not have the respective date as a column inside of it. 

 

I have to add an extra column that indicates the date of each file. Example:

Result I'm Getting:

Joker_Hazard_0-1631984799479.png

 

Desired Output:

Joker_Hazard_1-1631984850856.png

 

Any input is appreciated!! Thanks 

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Joker_Hazard 

 

Here is how you can do it.

Configure dynamic input tool to output filename which can be used for mapping.

atcodedog05_0-1631985614214.png

 

Workflow:

atcodedog05_1-1631985668348.png

 

Hope this helps : )

Qiu
21 - Polaris
21 - Polaris

@Joker_Hazard 
The first on is similar with @atcodedog05  and I have a second which looks simplier.

And I do recommend that put some file extension for the directory tool.

0919-Joker_Hazard-1.PNG0919-Joker_Hazard-2.PNG

Joker_Hazard
11 - Bolide

Thanks guys, both are very good solutions!! 

Thanks for the recomendation as well Qiu, very important indeed. 

Cheers

Qiu
21 - Polaris
21 - Polaris

@Joker_Hazard 
Glad to help and thanks for the accept mark. 😁

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Joker_Hazard 

Cheers and have a nice day!

Labels
Top Solution Authors