Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Split rows base on value

kflow
5 - Atom

Hi Team ,

 

I'm looking for a tools to split my data set accordingly.  The original data like below
Example :

Input : A001 Day 4 and B001 Day 1,3,6

 

Output:

A001, Day 4
B001 , Day 1
B001 ,Day  3
B001, Day  6

8 REPLIES 8
paulfound
11 - Bolide

You could use regex something like:

 

(\w\d+\s)Day\s(\d+)\sand\s(\w\d+\s)Day\s(\d+),(\d+),(\d+)

 

parse it to several columns

 

PaulFound_0-1573034378018.png

OllieClarke
15 - Aurora
15 - Aurora

Hi @kflow I also used RegEx, but broke it into a couple of steps:

OllieClarke_0-1573037060429.png

danilang
19 - Altair
19 - Altair

hi @kflow 

 

Does your data really come in the form "A001 Day 4 and B001 Day 1,3,6"?  What if you get a record for C001? Does it add an "and".

 

Could it actually come in on separate rows like 

A001 Day 4 

B001 Day 1,3,6 

 

Dan

kflow
5 - Atom

hi@danilang,

 

The original data is like below:

A001 Day 4 

B001 Day 1,3,6 

Julien_B
8 - Asteroid

You can do it this way : 
From this :

Julien_B_1-1573127260116.png

to that : 

Julien_B_0-1573127221236.png

benakesh
12 - Quasar

Hi @kflow ,

Try text to columns ( space delimiter) followed by  another text to columns ( , delimiter and split to rows ) .

benakesh_0-1573128670070.png

 

danilang
19 - Altair
19 - Altair

Hi @kflow 

 

Thanks for the clarification.  This workflow uses a regex formula to split the input columns into Type and Day and then a text to columns to split the day numbers into rows

w.png

After that, it's a question of how you want the output.  The top output is the most useful for further processing since [Day number] is a single numeric value that you can convert to a day name or a date.  The second output includes the "Day" label in the [Day] field.  the third output is similar to the output you included in the original post

 

Dan

kflow
5 - Atom

Thanks for your help, i'm able to do what i want with the simple flow.

Labels