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