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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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