Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Need to segregate one column into multiple column based on condition

Gsiva3
Astéroïde

Hello Team,

 

I have attached the sample input.

My query is to convert one column into 4 columns . I have data in input column as "ZZ98** ABCDEF ************* AAAAA UUUU" 

I want to split this above mentioned cell into 4 columns like 

1st Column - ZZ98

2nd Column - ABCDEF

3rd Column - AAAAA

4th Column - UUUU

I have attached the sample input and desired output here.

Please support me on this.

 

Input
ZZ98** ABCDEF  *************  AAAAA  UUUU
ZZ98INOT WORKING               GGGGG
ZZ98** SAMPLE INPUT  *************  JJJJJ
ZZ98***GHIJKLMNOP  *************  BBBBB  VVVV
ZZ98** SAMPLE OUTPUT  *************  KKKKK
ZZ98***KEEP THE DATA  *************  LLLLL
ZZ98***QSRTUVWXYZASDFG *************  CCCCC  WWWW
ZZ98***DON’T KEEP THE DATA *************  MMMMM
ZZ98***ERROR IN DATA ************* NNNNN
ZZ98***DO NOT CHANGE ************* DDDDD  XXXX
ZZ98***   PLEASE CHANGE      *****  EEEEE          01_09_1985
ZZ98ITS WORKING             FFFFF     +YYYYY          01_09_1985
ZZ98***   MARK THE DATA      *****  PPPPP
ZZ98   CONTROL NOT AVAILABLE      *****  OOOOO

 

Output 1Output 2Output 3Output 4
ZZ98ABCDEFAAAAAUUUUU
ZZ98INOT WORKINGGGGGG 
ZZ98SAMPLE INPUTJJJJJ 
ZZ98GHIJKLMNOPBBBBBVVVVV
ZZ98SAMPLE OUTPUTKKKKK 
ZZ98KEEP THE DATALLLLL 
ZZ98QSRTUVWXYZASDFGCCCCCWWWWW
ZZ98DON'T KEEP THE DATAMMMMM 
ZZ98ERROR IN DATANNNNN 
ZZ98DO NOT CHANGEDDDDDXXXXX
ZZ98PLEASE CHANGEEEEEE 
ZZ98ITS WORKINGFFFFFYYYYY
ZZ98MARK THE DATAPPPPP 
ZZ98CONTROL NOT AVAILABLEOOOOO 
11 RÉPONSES 11
Shifty
Quasar

@Gsiva3 - perfect!  Glad to hear it.

IraWatt
17 - Castor
17 - Castor

Great solution @Shifty ! 

Étiquettes