Appending each row from two tables

[apichart]

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

[Thableaus · Accepted 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,

[apichart]

That was quick! I love Alteryx community ;)

Thanks @Thableaus !