community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Add Date to Render Output File Name With Layout

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

Alteryx Certified Partner
Alteryx Certified Partner

Hi @AndrewKwast 

 

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

 

Cheers,

Highlighted
Moderator
Moderator

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

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.

Moderator
Moderator

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