Outputting multiple tables with different schema in multiple sheets

Hello Guys,

I am a newbie in the Alteryx environment and there is one thing I couldn't figure out even after reading multiple community threads.

I have 2 tables, with all but one same columns-

I need to output these to one excel file, which has multiple sheets and each sheet named after the values of "Dimension" column. Each sheet should have 2 tables as follows:

Any help would be great help. Thank you.

Developer Tools

Reporting

Common Use Cases

Accepted answers

pedrodrfaria

Hi @rs1

The best way to do this and not worry about how many rows, it would be to transform it in a table and output it via the render. See the workflow below using your dataset as well as the output file.

Pedro.

Outputting multiple tables with different schema in multiple sheets.yxmd

Output.xlsx

All comments

pedrodrfaria

Hi @rs1

The best way to do this and not worry about how many rows, it would be to transform it in a table and output it via the render. See the workflow below using your dataset as well as the output file.

Pedro.

Outputting multiple tables with different schema in multiple sheets.yxmd

Output.xlsx

carlosteixeira

Hi @rs1

Take a look this workflow

Outputting multiple tables with different schema in multiple sheets.yxmd

rs1

Hi @pedrodrfaria!!

Thank you so much for the solution, that worked perfectly for my use case.

If it won't take much of your time, can you suggest any method wherein we can omit the "Dimension" column from the final output (from all the sheets).

Thanks a lot,

Roopan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703