How to repeat column headers of the first table in a combined layout of 2 or more tables

I have a workflow with 2 individual input files that need to be combined into a single table report. It worked fine until I observed a particular record where the table flows into the 2nd page. Number 4222.

The column headers of the first input file don't seem to repeat when I combine the 2 tables into a single vertical layout.

I observed that if I use just one table in the record then it repeats. Any idea how I can get the behavior where the headers of only the first table repeat if the number of records flows to the second page?

I am attaching the files and workflow here.

Any help from the community is really appreciated.

1.xlsx

2.xlsx

Workflow.yxmd

Reporting

Help

Accepted answers

DavidP

I think what happening is that you're creating 2 reporting snippets and then stitching them together (a bit like cutting out 2 pictures and then gluing and pasting them together on a sheet of paper). Only one of the 2 has a header, which appears at the top of page 1 and since it is report 2 that spills onto page 2, it doesn't repeat report 1's header. Does that make sense?

My suggestion is to combine the datasets first with a Union tool (use the Auto config by position option) before turning it into a report, like so (note that you can specify the order in which the datasets are unioned):

Also see workflow attached.

joining tables.png

joining tables.yxmd

All comments

DavidP

Also see workflow attached.

joining tables.png

joining tables.yxmd

anirudh1

Thank you so much David! Your solution really solved my problem superbly.

I have one more question though.

With the very same table, I've added two text boxes one which indicates the Number1 as a heading which I've placed above the table

and the other that indicates a note for each table at the end. I understood what you said about stitching them together, but is there any way to repeat just this first heading text boxes on each page when it goes beyond one page?

These are probably really newbie questions but I looked at the sample workflows that are provided within the alteryx application and still couldn't figure this out.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703