How to put one table below second one

Hi,

I have a case that I cannot figure out. What I need is to place two different tables below each other. as seen on the picture both of them have different headers (marked in orange and yellow). How can I do it so they are position as on the screenshot below.

Appreciate your help.

ViTk0

Workflow

Accepted answers

markcurry

Hi @vkulhany

As @Emil_Kos mentioned the best way would be with the Reporting tools, but you can use the Union tool, but as the headers in the 2nd table will be strings, your data types will be strings. Using the union tool you will lose the headers from the 2nd table, so you would need to extract this information too. If there are more fields in the 2nd table than the first table, the resulting table will take the headers from the 2nd table. See attached....

Mark

Combine Tables.yxmd

All comments

Emil_Kos

Hi @vkulhany,

One of the ways is using the reporting tool. Taking into consideration that probably you want to make some fancy report I believe that might be the area that you should explore.

I have created a workflow for you:

The output:

To learn more about reporting tools I would advise to check the interactive lessons in the link below:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%20in%20Designer

Table.yxmd

markcurry

Hi @vkulhany

Mark

Combine Tables.yxmd

Luke_C

Another option in addition to the reporting tools mentioned might be to output each table to a specific excel range in your output file. This would give you more control over formatting, but might be tricky depending on the volume of records.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703