Add Date to Render Output File Name With Layout

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/114683#M34875

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

Reporting

Output

Date Time

Accepted answers

JeradR

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.

All comments

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

ReportNaming.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703