Adding repeat lines

[ll1100000]

What is the best way to format data From

UPC	SKU
62930020382	30485721, 2357550

To

UPC	SKU
62930020382	30485721
62930020382	2357550

Thank you.

[MarqueeCrew]

Parse.  Text to Columns.  Split to ROWS.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Text-To-Columns/ta-p/36256

Cheers,

Mark

[jdunkerley79]

Use a Text To Columns tool to split the SKU on , to rows

You may need to use a Data Cleanse tool to remove residual spaces.

Sample attached

[ll1100000]

Hi @jdunkerley79

I got the first part by split the columns... but how to get the second part to repeat the UPC column..

Thank you

[jdunkerley79 · Accepted solution]

If you set the Text to Columns tool to Split to Rows it should automatically repeat the UPC column (and any other columns).