In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Seperation

ntudev
8 - Asteroid

Hello,

 

How do i separate the info tab? i need it to look like the 

 

DateInfo
9/30/2022CLEAN, DIRTY

 

 

i need it to look like the 

DateInfo
9/30/2022CLEAN
9/30/2022DIRTY
4 REPLIES 4
Kakuffo
Alteryx
Alteryx

hi @ntudev  theText to columns tool would be the one. use the split to rows option and specify the delimer as a comma
Update -added workflow

Kakuffo_0-1668615294982.png

 

Sarreddy
9 - Comet

@ntudev 

Can you try like this.

 

Sarreddy_0-1668614801209.png

 

ShankerV
17 - Castor

Hi @ntudev 

 

Please find the solution 

 

ShankerV_0-1668615895613.png

 

 

Many thanks

Shanker V

 

Step 1: Input

 

Stpe2: 

ShankerV_1-1668615921259.png

 

Stpe3: 

 

ShankerV_2-1668615933317.png

 

 

Stpe4: 

 

ShankerV_3-1668615942663.png

 

 

Kindly accept this solution if it provided a solution to your question.

 

 

 

OllieClarke
15 - Aurora
15 - Aurora

@ShankerV , @Sarreddy as @Kakuffo showed, the Text to columns tool can also parse text to rows. so no need for transposing, or RegEx :)

Labels
Top Solution Authors