Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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
ericren
8 - Asteroid

ericren_0-1671138299868.png

 

PanPP
Alteryx Alumni (Retired)

Choose the "Replace FileName with group" option

 

Click the field to group on drop down also.. are there any columns that appear there? 

 

You can use a join tool right (joining the column with file name) towards the end in order to have a field with file name to choose from.

 

ericren
8 - Asteroid

Thanks, it worked. Now i am sending the file in an email.

 

How am I able to pickup the file in the email tool if the name changes based on date?

stnguyen
5 - Atom

Hi Felipe,

In my Render table, I'm referencing an excel output file that has data in it.  When I run the script, my file get's renamed correctly but my data gets replaced by the data in the render table.  How do I keep the data from my original excel output file?

 

Thanks,

Steve

Labels