Render Tool - Space between tables in Excel-Output

[FlorianH]

Hi 🙂

I have a workflow (see attached) that creates several tables with the "Group by"-functionality of a Basic Table Tool. With a Layout-Tool and a Render-Tool I than want to put these tables next to each other horizontally. In the Layout-Tool it looks good, but in the final Excel-Sheet there is no space at all between the tables.

Is there any easy solution to solve that problem?

I found this threat, which is similar, except that the tables are created with several Basic Table Tools, which is not the case in my workflow.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-put-space-between-tables/td-p/7...

Thanks a lot in advance!

Florian

[BrandonB · Accepted solution]

Hi @FlorianH 

I took some inspiration from this link, credit to @MichalM  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-Tables-in-one-Excel-sheet-mix... 

I adapted it a little so it would dynamically generate blank tables for spacing based on how many tables were generated from your process. 

Workflow is attached!

[FlorianH]

Hi @BrandonB,

the way to the goal is a little longer than I was hoping for 😉  but your solution works very well! Thanks a lot!

Regards,

Florian