concatenate every row in first column to all the rows in the second Column

Hi Team,

Does anyone know how to merge two columns as below,

Column1
1
2

Column 2
A
B

Output Column
1A
1B
2A
2B

Thanks in Advance

Best regards,
Sahil

Hi there!

You can use Cross Joiner node followed with Column Combiner node with following configuration - empty for Delimiter option and Replace delimiter by option ticket and also empty. It should do the trick :wink:

Br,
Ivan

Thank you so much Ivan:) Exactly what I was looking for!

Best regards,
Sahil

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