How to create empty rows between tables in excel output

Hi,

i need to output 2 tables into one excel sheet(vertically) and between the 2 tables there should be some empty rows

Have tried to create another table with null values and join the 3 tables together. I am able to get empty rows in final output but the height of the empty rows is very narrow. I actually want to to be the same as the other 2 tables which have values

I use render tool to output into excel, btw

Have tried to adjust the height of table layout but it didn't help

Anyone has a suggestion?

Tips and Tricks

Accepted answers

All comments

pedrodrfaria

Hi @ChloeZhao0122

Please see the workflow attached for an example of how to do this.

I used the report tool and added 2 blank rows to be the separator between the tables.

Please let me know if you were thinking something different. If this was the solution you were looking for, please remember to assign a solution to the post.

Pedro.

Table Space.yxmd

ChloeZhao0122

Hi,

i didnt get the expected output following your method... in the layout tool, i have to group by a field as i need to output the data into seperate excel files based on the field

Also i am using alteryx 2019 version, not sure if that also cause the issue ??

GideonM

Creative !!

Dave_Mosk

This is a good solution but what if you have multiple tables where you want a break in between each one?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335