Change filename using date from a column

[ericren]

Hi All,

I have a column below with just 1 dates for all rows.

Id like to grab the date and use it as filename.

Please help me with this, thank you. 

Date

12/15/22

12/15/22

12/15/22

[ChrisTX]

Check out the Dynamic Input tool.  Under the Developer tab, single-left-click the Dynamic Input tool, click Open Example, run the sample workflow, and review the sample output.

You may need to also use a Formula tool to incorporate your date into a text string like a Full Path (folder name and file name), going into the Dynamic Input tool.

Here's the Tool Mastery article:  https://community.alteryx.com/t5/*/*/m-p/24946

And the Tool Mastery index:  Tool Mastery Index - Alteryx Community

Chris

[Felipe_Ribeir0 · Accepted solution]

Hi @ericren 

You can use a workflow like this one to do that:

1) I used the formula tool to build the filename (it is without specifying the folder, so it will save at the same location of the workflow)

2)Inside of the output tool, you can configure it to take the filename from your the column generated by the above formula:

[ericren]

I am rendering a basic table. How am I able to incorporate the date?

[PanPP]

Hi @ericren 

You can render to an output path based on a column value by following the configuration in screenshot below..

Hope this helps. If it does, please like the post and mark it as a solution.

[Felipe_Ribeir0]

Hi @ericren 

Using your same example, here it is:

[ericren]

Not sure how I would connect formula tool to basic table?

[Felipe_Ribeir0]

Hi @ericren 

Using the render tool you dont need to specify the sheet. It is like this:

[PanPP]

Your data will essentially become tables and then you can use the field to group on the option to replace the file name.

Please take a look at @Felipe_Ribeir0  workflow

[ericren]

Hi Sorry, here is what I am working with. Where does the formula go? I cant use the formula tool from the layout. And it wont connect from the original intput.