Combining Tiled Outputs - Is this possible??

[bryan_ram2613]

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 Tile	23058
Extremely Low	28
Low	29
Below Average	57
Average	113
Above Average	36
High	1

# of Persons Tile	23060
Extremely Low	2
Low	180
Below Average	48
Average	18
Above Average	17
High	1

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 Residence	Tile Ranges	23058
	Extremely Low	28
	Low	29
	Below Average	57
	Average	113
	Above Average	36
	High	1
# of Persons	Tile Ranges	23060
	Extremely Low	2
	Low	180
	Below Average	48
	Average	18
	Above Average	17
	High	1

Any help is much appreciated. Thanks!

Best

[Claje]

Hi,

Seeing your workflow would help, but guessing at what you have configured, I set up a quick example (attached) of how to do this.

Essentially, I create the header row with the "Tile Ranges" value you are looking for separately for each Smart Tile, and union this together.  Then I union the final two outputs of these smart tile processes together to create your format.

I hope this helps to give you some ideas!

[DavidP · Accepted solution]

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.