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 to Columns

IJH34
8 - Asteroid

Hi,

 

I am trying to split this column in 24 additional columns.

010100000000000100100010

 

This column comes in a number of different sequences of 0's and 1's so regardless of the sequence each number needs its on column. The text to column doesn't work because I don't have a delimiter, and I'm not great with regex. 

 

Thanks in advance. 

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @IJH34,

 

My solution will work for column not a header. 

If you need a help with a header as well we need to use data input tool and choose option that the first row contains data. 

 

Hope this workflow will help you.

 

The dot in regex is like a joker 🙂 

 

Emil_Kos_0-1601478233752.png

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @IJH34 ,

 

Here is a workflow for the task.

 

Input

atcodedog05_0-1601478215850.png

Output additional 24 columns

atcodedog05_1-1601478233161.png

 

Workflow

atcodedog05_2-1601478259530.png

 

Hope this helps : )

 

If this helps please mark the post as solution.

atcodedog05
22 - Nova
22 - Nova

Hi @IJH34 ,

 

Additional you can look at this weekly challenge.

 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-234-Spell-It-Out-For-Me-Part-1/td-p/6363...

 

Which used the same concept.

 

The first post this also has a explanation on how this is done.

 

 

jdunkerley79
ACE Emeritus
ACE Emeritus

A Regex tool in tokenise mode will act like a text to columns.

 

If you use and expression of [01] then it will look for either a 1 or a 0 and fill to each column (make sure to choose 24!)

Labels