Combining Tiled Outputs - Is this possible??

Question

Hello All,

I have run into a snag when it comes to formatting an output. It might not be possible but here gos.

I have these two smart tile outputs within the same workflow. Those are shown below.

Residence Tile23058Extremely Low28

Low29Below Average57Average113Above Average36High1

# of Persons Tile23060Extremely Low2

Low180Below Average48Average18Above Average17High1

Is it possible to get this output to look like this?? I am trying to stay in Alteryx and not output to excel and reformat the output.

Length or ResidenceTile Ranges23058 Extremely Low

28 Low29 Below Average57 Average113 Above Average36 High1# of PersonsTile Ranges23060 Extremely Low2 Low180 Below Average48 Average18 Above Average17 High1

Any help is much appreciated. Thanks!

Best

DavidP · Accepted Answer

Perhaps I'm imagining a different problem to the one you actually have. If you already have the data from the 2 tiles, lumping them together and making a few changes to match your desired output is pretty easy, like this:

Then I thought, perhaps the 1st row of each dataset is actually the header row, so then it's not as straightforward, you have to make the header row part of the dataset first, and then you can union them together, like this.

Both solutions are attached.