Hello everyone, Im trying to achieve the below. I had seen this before but Im not able to recollect how it was done. Data Column AColumn BA1B2C3 Result To achieve Column AColumn BA1A2A3B1B2B3C1C2C3 Your help would be highly appreciated.

Duplicate Rows with Different Content

Hello everyone,

Im trying to achieve the below. I had seen this before but Im not able to recollect how it was done.

Data

Column A	Column B
A	1
B	2
C	3

Result To achieve

Column A	Column B
A	1
A	2
A	3
B	1
B	2
B	3
C	1
C	2
C	3

Your help would be highly appreciated.

Common Use Cases

Join

Interface Tools

Accepted answers

atcodedog05

Hi @Faisal___28

Try this and make sure the Append tool it set to allow all append (refer highlighted). Hoping Blank values are Null.

Hope this helps : )

combo.yxmd

All comments

atcodedog05

Hi @Faisal___28

Here is how you can do it.

Workflow:

Hope this helps : )

combo.yxmd

AkimasaKajitani

Hi @Faisal___28

This workflow will work well.

sample_Cartesianproduct_AK.yxmd

Faisal___28

Hi @atcodedog05 ,

Thanks for the solution but im facing another issue as I dont have equal no. of records in both the columns. Column A contains 7000 records and column B 64. Hence im not able to replicate for all the records. Pls help

Faisal___28

Hi @atcodedog05,

I believe there is a limitation in the number of outputs. I ran the workflow twice with the two sets to achieve my result. Thanks for the help.

atcodedog05

Happy to help : ) @Faisal___28

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703