community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Separating data in a coulmn

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

Alteryx Certified Partner
Alteryx Certified Partner
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 reboot. Order shall return.
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).

Alteryx Certified Partner
Alteryx Certified Partner
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 reboot. Order shall return.
Asteroid

Col 1 col 2 are the desired output

Highlighted
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.

Quasar

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

 

workflow.PNGWorkflowResults.PNGResults

Labels