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

Separating data in a coulmn

razzy
8 - Asteroid

Hi all i have a data set , with a column containing two different information.

one information contains  alphanumeric characters which i need a new column and the other is purely textural without any numbers and that i also need in a separate column. I know i can use Regres but then how do i configure it to filter the column, the data set is attached below.

Thanks for helping

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus
Did you want to filter these values?

Contains([description],"<")

That will find them.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
razzy
8 - Asteroid

Thanks Mark. 

It is not giving me the output. So when i use the filter tool it gives no output with this formula

Contains([Primary diagnosis], "<")

When i run the code on the formula tool it outputs a column with 0 zeros

So what i want to do is to provide two column one with the terms (m.4536C>T) and another without those values but description ( text or whatever is contained without the terms coded).

MarqueeCrew
20 - Arcturus
20 - Arcturus
For each row in your excel file can you create 2 columns with the desired results please?
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
razzy
8 - Asteroid

Col 1 col 2 are the desired output

DHB
8 - Asteroid

You could parse then apply an if function.

1. 3.PNG

2. 1.PNG

3. 2.PNG

4. Gives you...

4.PNG

 

 

'Complex I' is a letter I though (capital i) not a 1.  You could use another if function to turn those into 1's not i's.

ponraj
13 - Pulsar

Here is the sample workflow for your case. Hope this is helpful. 

 

WorkflowWorkflowResultsResults

Labels