Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

column with multiple delimited IDs

Highlighted
7 - Meteor

i have a data set that i received that contains some customer grouping information where a single customer has multiple IDs rolling up to it, but they're in a single row:

 

CUSTOMER | GROUP CODES| DATA....

12342  | AAA/BBB/CCC

12341 | DDD

13563| EEE/FFF

 

Is there any way to somehow 'tidy' up the group codes column and create multiple rows? 

 

for example:

 

AAA | 12342  

BBB | 12342  

CCC| 12342  

DDD|12341 

 

in reality i'm trying to create a distinct mapping for group code to the overarching customer, but the number of group codes per customer can be variable. 

 

thanks in advance!

Highlighted
11 - Bolide
You can use Text To Columns, and split your Group Codes field by the slash, and choose the Split to rows option
Highlighted
12 - Quasar

@mompermj ,

You can use Text to columns for  splitting  columns and creating rows for group codes.

benakesh_0-1572026363840.png

Highlighted
7 - Meteor

thanks again. i didn't realize that i never thanked you. 

Labels