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.
My upper table is a pivot of ID, Months and Year(2013,2014,2015,2016) . The lower one has ID and year too.
I am trying to get an output in such a way that my output file has 4 tabs, each for one year. Each tab will have the 2 tables associated with that year, the upper table and the lower table. And I have an Output tool at the end.
So when I use the Join Multiple tool, it throws an error "You must specify a sheet name".
Is there any way I can fix this?
It's just the last step. Thanks for all your help.
I think I understand what you are trying to accomplish. It is probably easiest to make a separate table for each upper and lower table, bring them together in a layout tool, and then configure the render tool as follows. You will not need an output data tool at all, just a Render tool. In this example, tables are created for two sets of upper and lower pivots. You can create these by filtering for year from your main data set. Then the top group is fed into a join multiple and then a layout tool in order to configure how it will look on the spreadsheet. Then the second group has the same process done. The layout tool produces layout objects that can then be rendered. You can stack these together using a union tool as seen below and then feed into the render tool. The render tool should then be configured to "Insert Section Breaks Between Records". This will then render each layout object into its own sheet in the Excel document as seen in the second picture.
The reason that we are not using an output data tool is due to the fact that we are creating layouts of multiple data tables to then be put into the same Excel sheets. This can only be done via the render tool.