Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
16 - Nebula

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
20 - Arcturus

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
20 - Arcturus

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
16 - Nebula
16 - Nebula

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