Joining 2 Cross tabs

[GP2]

Hi All,

I am trying to join the results of two cross tabs. Is this possible?

Output 1:

Output 2

I would like the Region data columns to come alongside the divisional columns to give room id with 14 columns

[rkapoor · Accepted solution]

@GP2 you should be able to do this simply with the Join tool and treat these outputs as data inputs.

If you want, book a Virtual Session with an expert and we can get this resolved.

https://community.alteryx.com/t5/Virtual-Solution-Center/tkb-p/vsc

[Qiu · Accepted solution]

@GP2 
Will not the Join tool do the trick?

[GP2]

Thanks, yeah that work