We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Add Date to Render Output File Name With Layout

AndrewKwast
7 - Meteor

I need to include a date in my final output's file name using the Render tool.

 

I've seen previous suggestions that say to create a filename date field and use the group data configuration of the Render tool:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Add-date-to-filename-in-Render/m-p/114...

 

The problem is I've used the Layout tool, rather than the Table tool, before using the Render tool.

Thus, I'm getting the "No Valid Fields" message when I go to group the data in Render.

 

Does anyone have any solutions to keep the report formatting/layout while also being able to include a date in the output file name in Render?

 

Render File Name.PNG

Render Config.PNG

4 REPLIES 4
Thableaus
17 - Castor
17 - Castor

Hi @AndrewKwast 

 

The field used to group must be a non-reporting field. Like a String, numeric field.

 

Cheers,

JeradR
Alteryx
Alteryx

Hi @AndrewKwast,

 

Try creating your groups earlier within the workflow, like within the Table tool. Then use an Append Fields tool to append the Header and the Report Text to each individual table. Please see the attached example (you may need to tweak it based on your needs). Does this help solve your problem?

 

Jerad

AndrewKwast
7 - Meteor

Hi @JeradR,

 

Could you post a screenshot of your example? I'm using an older version of Alteryx so can't open the file.

JeradR
Alteryx
Alteryx

ReportNaming.png

 

PRO TIP: Extract the workflow package with something like 7zip, then open the workflow with a text editor and modify the 'yxmdVer' value. Adjusting Alteryx Files for Different Versions.

Labels