We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Change filename using date from a column

ericren
8 - Asteroid

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
13 REPLIES 13
ChrisTX
15 - Aurora

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
16 - Nebula

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)

 

Felipe_Ribeir0_0-1671136924268.png

 

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

Felipe_Ribeir0_1-1671137014111.png

 

ericren
8 - Asteroid

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

 

ericren_0-1671137373810.png

 

PanPP
Alteryx Alumni (Retired)

Hi @ericren 

 

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

 

 

renderpath.png

 

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

Felipe_Ribeir0
16 - Nebula

Hi @ericren 

 

Using your same example, here it is:

Felipe_Ribeir0_0-1671137939459.png

 

ericren
8 - Asteroid

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

Felipe_Ribeir0
16 - Nebula

Hi @ericren 

 

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

 

Felipe_Ribeir0_0-1671138053948.png

Felipe_Ribeir0_1-1671138074912.png

 

 

PanPP
Alteryx Alumni (Retired)

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
8 - Asteroid

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.

 

ericren_0-1671138198509.png

 

Labels