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

Dividing field into columns with non ordered values

ievpal
7 - Meteor

Hi,

 

I have a field in my data, which I want to divide into columns. However, I cant use Text to Columns tool as data in my columns is not ordered.

I already have list of columns that should be made.

 

Sample of my data:

 

 Tags

RUNS:1,VERSION:7.2,OUTPUT:TXT,

VERSION:7.1,RUNS:1,OUTPUT:CSV,

RUNS:1,OUTPUT:CSV,VERSION:7.2,

OUTPUT:CSV,OWNGROUP:Y,VERSION:7.1,REASON: OTHER

 

 

Result I want to get:

 

RUNSVERSIONOUTPUTOWNGROUPREASON
17.2TXT  
17.1CSV  
17.2CSV  
 7.1CSVYOTHER

 

4 REPLIES 4
patrick_digan
17 - Castor
17 - Castor

@ievpal I've certainly overcomplicated the matter, but the key for my approach was using the unique tool. A simpler approach isn't immediately coming to mind.

MarqueeCrew
20 - Arcturus
20 - Arcturus

@ievpal,

 

I got a little more sleep than @patrick_digan.  Here's my solve:

 

Screen Shot 2016-11-30 at 8.01.48 AM.png

 

I used multiple passes for parsing the data (rows and then columns) and then brought the data back together in a crosstab (naturally orders fields alphabetically).  I then used a select to reorder the columns and remove a RecordID field.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
ievpal
7 - Meteor

Thank you both on a quick reply! :)

lminors
9 - Comet

Another slightly complicated solution. Dividing workflow up into RUNS, VERSIONS etc and then combining the fields and parsing on the colon.

Labels