Data Layout

[rajputakansha]

Hi all,

I am trying to arrange my the output vertically into 2 sections from 

to

 

The first screenshot is the output of Layout tool. Is there any way to arrange the data in 2 vertical sets?

Thanks

[BrandonB]

Are you using a render tool as well as an Output Data tool to the same Excel file at different parts of your workflow?

[benakesh]

Hi  @rajputakansha ,

Can you share your workflow ?  

Can you remove  the empty columns  in  sheet  ?  

[rajputakansha]

Hi @benakesh , @BrandonB ,

I am using this workflow:

And as you mentioned above @benakesh I am trying to figure out exactly that.

I need to arrange the columns in such a way that I see one below the other.

Thanks

[BrandonB]

Hi @rajputakansha 

Instead of using a union tool, try a join multiple tool and join on position. The tables need to be on the same row feeding into the layout tool. This should take care of your issue.

[rajputakansha]

Hi @BrandonB 

,

Thanks for your suggestion.

There is one small problem in this. 

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.

Thanks

 

[BrandonB · Accepted solution]

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. 

[BrandonB]

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. 

[rajputakansha]

Hi @BrandonB ,

I used the logic from your screenshot and it worked!! Exactly how I wanted.

However, I am getting multiple blanks tabs between each tabs(for year). Do you know why that's happening?

Thanks

[BrandonB]

Feeding into your render tool, are each of your layout objects stacked on top of each other? It should feed in like below

Blank tabs would indicate that there is either no data in the layout object, or if you have blank rows without a layout record. 

[rajputakansha]

@BrandonB Thanks a lot for your help!

I got exactly what I needed.

🙂