Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Split of columns and rows based on delimiter

sakshim
8 - Asteroid

I want to split values in my columns to different rows, I have used TEXT to COLUMN Tool but that can split only 1 column at time. I have a below table for which I want 1:1 split of  Columns DEPT, Description , DEPT ID & Dept Value :

SNOBusiness DateCodeDept descriptionDept IDDEPT ValueStatus
100117-Mar-22ED/N0000GCRS Account, Facilities238,01240,6Active
100217-Mar-22ED/N0000Facilities, Transport, HR, IT012, 123, 435,3216,23,24,54Active
100317-Mar-22ED/N0000Corp finance, Operations321,54365,23InACTIVE
100417-Mar-22ED/N0000GRC,IT023,24ACTIVE

the output should look like:

SNOBusiness DateCodeDept descriptionDept IDDEPT ValueStatus
100117-Mar-22ED/N0000GCRS Account23840Active
100117-Mar-22ED/N0000Facilities0126Active
100217-Mar-22ED/N0000Facilities0126Active
100217-Mar-22ED/N0000Transport12323Active
100217-Mar-22ED/N0000HR43524Active
100217-Mar-22ED/N0000IR32154Active
100317-Mar-22ED/N0000Corp finance32165InACTIVE
100317-Mar-22ED/N0000 Operations54323InACTIVE
100417-Mar-22ED/N0000GRC023Active
100417-Mar-22ED/N0000IT024Active

 

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @sakshim ,

 

Here's one way you can do this

 

AngelosPachis_0-1647854306644.png

Cheers,

Angelos

DavidP
17 - Castor
17 - Castor

Hi @sakshim 

 

I followed a very similar approach to @AngelosPachis, with the main difference that I used a Tile tool instead of Multi Row to create the individual row IDs needed for the CrossTab tool.

 

The Tile tool is often overlooked. The way I often use it is like a Record ID with Group By functionality. It's a handy tool to have in your back pocket.

 

DavidP_0-1647856523317.png

 

 

 

sakshim
8 - Asteroid

Thankyou both this had been really helpful

Labels
Top Solution Authors