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!"
That is the exact description of the Append Tool!