This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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