Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Dynamically rename output file with render tool (several layouts with tables and graphs)

5 - Atom

Hello everyone, I try to dynamically rename file with render (table/graph) tool.

I have several layouts with tables and graphs, then I join the layouts and render to excel file. Since I need to have the report every month, the ideal situation is that it dynamically rename the render excel file by month (specified in the data). 


I have looked at some solution some solutions. The following solution suggests use "group data into seperate report". But I failed to do so because I have several layouts, or maybe I didn't do it in the right way?


Could someone help me with it? Thank you in advance. 

17 - Castor
17 - Castor

Hi @ccyrs5204 


Take a look at the attached WF.  



It has multiple elements that are joined and then passed through a render tool.  The top input has a filename that the Formula tool adds the current month to.  The Render tool uses this tool to set the output file name using the following config





If you have several layouts that you're trying to get into the same file, make sure that you've got them all one final layout.  Think of it as Lego blocks.  Lets say you want a Image as a header.  Underneath this you want a graph that's beside it's corresponding table.  Finally you finish it off with a text analysis.  Think of this a 1x2 block(header) on top of a 2 1x1 blocks(graph and table) that sit on top of another 1x2 block.  Use a Layout tool to combine the graph and table into one layout.  Then join this layout with the image and text and use another Layout tool to position them all into one final layout.  Send this layout to the render tool, configured to "Replace Filename with Group



5 - Atom