Free Trial

Alteryx Designer Desktop Discussions

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

How to merge 2 tables?

emmazyan
5 - Atom

I’m working with two tables in Alteryx, one with row titles 'a, b, c' and the other with '1, 2, 3'. Both tables have 3 rows before merging.
How can I merge them to create combined fields 'a1', 'a2', 'a3', 'b1', 'b2', 'b3', 'c1', 'c2', 'c3', resulting in a total of 9 rows? I also aim to set the second column in the merged table to all 0s.

Any guidance is appreciated!"

2 REPLIES 2
CoG
14 - Magnetar

That is the exact description of the Append Tool!

nagakavyasri
12 - Quasar

Hi, check if this matches your requirement:

 

 

Capture2.PNG

Labels
Top Solution Authors