Free Trial

Alteryx Designer Desktop Discussions

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

Superimpose two tables

Ous1995
5 - Atom

Hello, 

I have two tables where the non-empty elements of one are not located in the same place as the non-empty element of the other, and i want to superimpose the two tables so that I obtain a table with all the elements,

For example, i have these two tables :

12 
   
3  

   

  2
14 
   

 

And i want to get : 

122
14 
3  

 

How can i do this in Alteryx ? 

Best regards,

 

2 REPLIES 2
CoG
14 - Magnetar

This can be done with Transpose, Union, and Cross-Tab like so:

Screenshot.png

Qiu
21 - Polaris
21 - Polaris

@Ous1995 
Since it is superimpose, then we just have the row# and column#

1207-Ous1995.png

Labels
Top Solution Authors