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 a value from a row into separate rows

Luk88kk
8 - Asteroid

Good morning,
Could someone please help me to split a value from a row into separate rows.
It looks like this:

 

Luk88kk_0-1640858946647.png

 

 


And this is how I would like it to look:

 

Luk88kk_1-1640858974745.png

 

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @Luk88kk ,

 

You can use a text to column tools to split to rows on every new line and then remove the commas from the right hand-side of the string.

 

AngelosPachis_0-1640859592674.png

 

Luk88kk
8 - Asteroid

Thank you very much. It works great!
Happy New Year:)

Labels
Top Solution Authors