Two Sheets with Separate Data Dynamically Output

[pacopenamedina]

What I want the end result to be is, an excel file with two sheets, one with a quarterly data table, and one with a monthly data table. I need to have multiple different excel files of this type. Currently using the reporting tools I am able to create the Excel files with quarterly data, but don't know how to add a sheet to each of those excel files to add in the monthly data table I want. Is there a way to get this done?

Thank you for any assistance.

[pacopenamedina]

one of the manners I am attempting to accomplish this is by using a group by so that i will create the two sheets, but there are some null columns then, is there any way to get rid of null columns in the render tools?

[binu_acs]

@pacopenamedina would you be able to provide a sample input file and expected output result?

[dwstada · Accepted solution]

 

have you tried something like this?

calculate your monthly/quarterly data separately, label them in a sort column, then use the sort column in your output tool. with excel files, this configuration will create a sheet for each distinct component of your sort column (with .csv files it will create separate files)

[pacopenamedina]

This is very similar to what I ended up doing! I used the layout report tool for the separate data, then I performed a union on it and used one render tool, I was able to adjust the settings to get the names to my liking. Thanks for the help!