Alteryx Designer Desktop Discussions

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

Combine two dataset without any common field

ilovecoding
8 - Asteroid

Hi, I am looking to combine 2 dataset wherein one will be my header and other will be the all fields under these headers in same order. How can i do it in Alteryx?

ilovecoding_0-1678346437951.pngilovecoding_1-1678346451017.pngilovecoding_2-1678346463088.png

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @ilovecoding 

 

Please use the union tool, using the below setting.

 

ShankerV_0-1678346574129.png

 

Many thanks

Shanker V

 

ShankerV
17 - Castor

Hi @ilovecoding 

 

Please find the sample use case related to your scenario.

 

ShankerV_0-1678346756837.png

 

Dataset1: 

 

ShankerV_1-1678346783569.png

 

Dataset2:

ShankerV_2-1678346802966.png

 

ShankerV_4-1678346840097.png

 

 

ShankerV_3-1678346825422.png

 

 

Many thanks

Shanker V

Labels