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

Search and Extract string into column

qlikvw2019
7 - Meteor

I have a column name "log" , it will have lots of details, i want to extract below 

 

....penalty: Low .....

 

OR

...penalty: Medium.....

 

I want to extract put the Low or medium in a separate column. Low/Medium will always be mentioned in the same format, right after

penalty:

2 REPLIES 2
ponraj
13 - Pulsar

It would be great if you could share sample data

AbhilashR
15 - Aurora
15 - Aurora

Hi @qlikvw2019, you could create a formula field with a logic that would look something like the below. It assumes column log will have penalty: Low of penalty: Medium as a string in it.

IF Contains([log],'penalty: Low') 
	THEN 'Low'
ELSEIF Contains([log],'penalty: Medium') 
	THEN 'Medium'
ELSE NULL()
ENDIF

If this doesn't work, please provide us a sample dataset for us to look at.

Labels