Hi,
Apologies in advance for such a foolish question as I have just adopted Alteryx.
I have two tables listed below. Although, it is quite a simple task, I do not know how to go to each record in table A and derive to all records in table B.
table A table B
foo1 A
foo2 B
foo3 C
D
My desirable output should be:
Table C
foo1A
foo1B
foo1C
foo1D
foo2A
foo2B
foo2C
foo2D
... and so on.
Appreciate for any suggestions
Thanks!
Apichart
Solved! Go to Solution.
Hi @apichart
Append Fields Tool is what you're looking for.
If you want to bring everything in a single record, you can concatenate them with a Formula Tool after doing the appending by - Fieldl1 + Field2
Cheers,
That was quick! I love Alteryx community ;)
Thanks @Thableaus !