Hi I have 2 excel files as input and need the 3rd file as the output in alteryx designer
File 1
Input Column 1 |
A |
B |
C |
File 2
Input Column 2 |
1 |
2 |
3 |
Desired Output
Required Column |
A1 |
A2 |
A3 |
B1 |
B2 |
B3 |
C1 |
C2 |
C3 |
#NewbieinAlteryx
Regards,
Hitesh
Solved! Go to Solution.
Hi @HiteshChandwani,
You need to have fun with union tool.
Please see a configuration of this union tool and make something similar.
Hi Emil,
Thanks for the reply
the suggestion you gave just lists out all the values in both the sheets
however what i am looking for is
for each value in sheet 1
list values of sheet 2 with the prefix of value from sheet 1
in sheet 3
Thanks in advance.
Regards,
Hitesh
Hi @HiteshChandwani,
My bad. I was able to replicate the desired output table.
They are not in the separate sheets but you will have a needed column.
was able to get it resolved using append and generate rows
thanks for your time 🙂