Duplicate rows based on possible combinations of cells

Hello all, I’d really appreciate your assistance on how I can perform the following operation:

My data looks like this, a combination of two sets of cell values


|Sad |Frown|2|

My desired output is to have every combination of the sets of each data replicated like such:
|Apple|Red|Sad |Frown|2|
|Banana|Green|Sad |Frown|2|
|Grape|Purple|Sad |Frown|2|

So the data replicates and matches based on how many combinations are available. Is this possible to execute? I’d really appreciate the assistance. Thank you!

Hi @FluffyTherese
cross joiner node should do the job.



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.