Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help needed to extract data and then join. Plz help

Onemajor
7 - Meteor

Here is the raw data: 

ItemNumDescriptionAvailableMinQtyCase SizeUPC
ML1213PKPrincess, Frozen & My Little Pony 24pk Nails on Clamshell115711216" x 15" x 9"719565377396, 719565356193, 719565356216

 

Final output should look like this: 

ItemNumDescriptionAvailableMinQtyCase SizeUPC
ML1213PKPrincess, Frozen & My Little Pony 24pk Nails on Clamshell115711216" x 15" x 9"719565377396
ML1213PKPrincess, Frozen & My Little Pony 24pk Nails on Clamshell115711216" x 15" x 9"719565356193
ML1213PKPrincess, Frozen & My Little Pony 24pk Nails on Clamshell115711216" x 15" x 9"719565356216
2 REPLIES 2
MilindG
12 - Quasar

@Onemajor You can use text to column tool

Onemajor
7 - Meteor

I have never used this tool as split to rows. Thank you @MilindG for you help. 

Labels