Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Combining two reporting tables into without repeating headers

Travis_Ratliff
8 - Asteroid

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

Travis_Ratliff_0-1664393576741.png

 

Thanks for the help

 

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

Hi @Travis_Ratliff 

 

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

binuacs
21 - Polaris

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

 

binuacs_0-1664395990692.png

 

kathleenmonks
Alteryx
Alteryx

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. 

 

kathleenmonks_0-1664395847209.png

 

Garabujo7
Alteryx
Alteryx

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

 

Garabujo7_0-1664396043435.png

 

You may use it like this:

 

Garabujo7_1-1664396120615.png

 

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
7 - Meteor

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 ?

Labels
Top Solution Authors