How to arrage columns in order after using Table Tool and Union Tool

[munipavankumar]

Hi Team,

Please help on this issue. I have also attached sample workflow and Image. Thanks.

[OTrieger]

@munipavankumar 
It will not be the best way, however if you will ensure that all 3 tables has the same number of columns then you data will be aligned in the way that you want. 

The issue is not with Alteryx but excel, as all the data is in one sheet but the width of them is the same it seems when you open in Excel as if the data is not sitting in the correct cells.

I know that this is not a perfect solution, but it gives you the output that you want to have.

[apathetichell]

render thinks of what it's creating as "desgined to print" - and it excepts one dimensional layout per file. This is a pain when you are looking to have wildly varrying numbers of columns on different sheets. The best solutions I've used are 1) use template files vs render (and blob tools/overwrite sheet range) 2) create all sheets via render - create only column headers for the sheet which doesn't fit your other layouts the most (ie the narrowest or widest) - use output data AFTER creating via render to overwrite the sheet (not keeping formatting). recognize that that won't be excel formatted.