Iterate on records and concatenate the values

[am50]

Hello,

i am new to alteryx and trying to accomplish bellow, i have two fields in my data set. i need to iterate on each value in field 1 and concatenate with each value from field 2.

for example :

Field 1 Field 2

a 1

b 2

c 3

4

5

expected output :

a1, b1, c1,

a2, b2, c2

a3, b3, c3

a4, b4, c4

a5, b5, c5

Please let me know how to accomplish this?

[LordNeilLord · Accepted solution]

Hey @am50

I'd append the records to themselves, this will give you every possible combination..then a bit more Alteryx magic to arrive at the end result.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[am50]

Great, it works, appreciate your help!