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

Multi-Field Text to Columns (Rows)

EricDM
6 - Meteoroid
Joe,
 
I have a similar issue and have attempted to use your workflow as a starting point, but am failing to get the output that I need.  Can you assist?
This is the data as it is provided to me (There are many additional rows and columns that I have cut out to simplify):
 
Pipes delineate the Control entries
ID
Control1
Control2
Control3
Control4
Control5
Control6
Control7
Control8
OtherData1
OtherData2

AB-1
12|DD|AC
 
LL|BMI|CR|BC|BB
LCA
B55
KMG64
LRE|LRD|LRF|LRG
S|T|A|L|W|Q
This is a
Number of
DC-1
 
123|213|312
 
NAB|BAM
RED|REM
 
KWW|KZL|KQQ|LLM
CD1|CD2
Went Left
Correct
XX-3
AQ
SS
ZAZ
LBZ
ZAD
PP
B204|B211|B300
J11|J006
Adjacent
Marko
 
And this would be the desired output:
ID
Control1
Control1
Control1
Control2
Control3
Control3
Control3
Control3
Control3
Control4
Control5
Control6
Control7
Control7
Control7
Control7
Control8
Control8
Control8
Control8
Control8
Control8
OtherData1
OtherData2
AB-1
12
 DD
 AC
 
 LL
BMI 
CR 
BC 
BB  
LCA
B55
KMG64
LRE
LRD
LFR
LRG
S
T
A
L
W
Q
This is a
Number of
Etc...
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
So instead of creating a RecordID, I need to go off the ID.
 
Thanks in advance,
 
Eric
6 REPLIES 6
Joe_Mako
12 - Quasar

How about the attached?

 

(Edited)

change shape.png

EricDM
6 - Meteoroid

Needed to update the output requirement.

EricDM
6 - Meteoroid

Sometimes, life is redonkulous...

 

Output has changed again.

 

This is the way the data comes to me.  Pipes delineate the Control entries

IDControl1Control2Control3Control4Control5Control6Control7Control8OtherData1OtherData2

AB-1

12|DD|AC LL|BMI|CR|BC|BBLCAB55KMG64LRE|LRD|LRF|LRGS|T|A|L|W|QThis is aNumber of
DC-1 123|213|312 NAB|BAMRED|REM KWW|KZL|KQQ|LLMCD1|CD2Went LeftCorrect
XX-3AQSSZAZLBZZADPPB204|B211|B300J11|J006AdjacentMarko

 

This is how I have been asked to provide it.  If it changes again, I might consider working the fry machine at McDonalds.  :-)

Notice now that they would like the controls grouped into their own heading and another column for the details...

 

IDControlControl DetailOtherData1OtherData2
AB-1Control112This is aNumber of
AB-1Control1DDThis is aNumber of
AB-1Control1ACThis is aNumber of
AB-1Control2 This is aNumber of
AB-1Control3LLThis is aNumber of
AB-1Control3BMIThis is aNumber of
AB-1Control3CRThis is aNumber of
AB-1Control3BCThis is aNumber of
AB-1Control3BBThis is aNumber of
AB-1Control4LCAThis is aNumber of
AB-1Control5B55This is aNumber of
AB-1Control6KMG64This is aNumber of
AB-1Control7LREThis is aNumber of
AB-1Control7LRDThis is aNumber of
AB-1Control7LRFThis is aNumber of
AB-1Control7LRGThis is aNumber of
AB-1Control8SThis is aNumber of
AB-1Control8TThis is aNumber of
AB-1Control8AThis is aNumber of
AB-1Control8LThis is aNumber of
AB-1Control8EThis is aNumber of
AB-1Control8QThis is aNumber of

 

I have a workflow developed, but I am unable to get the Control Details column to output correctly and it appears that the Control column is not plotting in the correct order, even going off of a Record ID that has been inserted.

Joe_Mako has been a life saver!!  I like that he includes example workflows so that I can learn what each tool is actually doing.

EricDM
6 - Meteoroid

I have successfully confused myself after receiving several output requests.  I am now being asked to create a new column that will contain the Controls and another that will contain the details.  But I still need the sort on the ID and include the other data fields.

 

Here is how the data is delivered.  Pipes delineate the Control entries

IDControl1Control2Control3Control4Control5Control6Control7Control8OtherData1OtherData2

AB-1

12|DD|AC LL|BMI|CR|BC|BBLCAB55KMG64LRE|LRD|LRF|LRGS|T|A|L|W|QThis is aNumber of
DC-1 123|213|312 NAB|BAMRED|REM KWW|KZL|KQQ|LLMCD1|CD2Went LeftCorrect
XX-3AQSSZAZLBZZADPPB204|B211|B300J11|J006AdjacentMarko

 

And this would be the desired output:

IDControl NameControl DetailsOtherData1OtherData2
AB-1Control112This is aNumber of
AB-1Control1DDThis is aNumber of
AB-1Control1ACThis is aNumber of
AB-1Control2 This is aNumber of
AB-1Control3LLThis is aNumber of
AB-1Control3BMIThis is aNumber of
AB-1Control3CRThis is aNumber of
AB-1Control3BCThis is aNumber of
AB-1Control3BBThis is aNumber of
AB-1Control4LCAThis is aNumber of
AB-1Control5B55This is aNumber of
AB-1Control6KMG64This is aNumber of
AB-1Control7LREThis is aNumber of
AB-1Control7LRDThis is aNumber of
AB-1Control7LRFThis is aNumber of
AB-1Control7LRGThis is aNumber of
Etc...    

 

Joe_Mako is a life saver...learning more from him in the past few days that I have in the last few weeks on my own.

Joe_Mako
12 - Quasar

change shape v2.png

rohanonline
10 - Fireball

You can try this as wellChange shape.JPG

 

 

Labels