Add Date to Render Output File Name With Layout

[AndrewKwast]

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?

[Thableaus]

Hi @AndrewKwast 

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

Cheers,

[JeradR]

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]

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 · Accepted solution]

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.