Combining two reporting tables into without repeating headers

As the subject says I have a workflow that produces multiple tables all with the same header but in different tables so that I can use different rules. Is it possible to then combine these tables into one without repeating the headers. The attached picture shows a basic part of what I have and what I would want is for those tables to be joined together as one

Thanks for the help

Reporting

Custom Tools

Help

Accepted answers

kathleenmonks

Hi @Travis_Ratliff,

In every table besides the first one, you can deselect the option to "Show Column Headings" Then, after unioning the two tables, you can use a layout tool and set the layout mode to "All records combined" and the Orientation to "vertical merge contents to line up table columns" and you will get the results in the screenshot below. I have also attached my workflow.

I used a row rule to color all the rows in Table 1 as blue to show that you can have different row rules per table and join them back together.

merge_tables.yxmd

All comments

Felipe_Ribeir0

Hi @Travis_Ratliff

If i understood well, why dont you union the data and put just one table report after the union?

binu_acs

@Travis_Ratliff One option would be union the data before the table tool

kathleenmonks

Hi @Travis_Ratliff,

I used a row rule to color all the rows in Table 1 as blue to show that you can have different row rules per table and join them back together.

merge_tables.yxmd

Garabujo7

Hello, to join the two tables together and design the report layout you could use the Layout tool.

You may use it like this:

Union or join the reporting tools and then the layout to arrange the elements.

You could see an example in the one tool example of the Layout. Just like you did in your example.

PARESH

Hello,

What if I do not have any data in first table but still I want to combine table with header only ?

In that case it is not showing first table itself, do you have any workaround on this type of table merging ?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703