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:
Solved! Go to Solution.
It would be great if you could share sample data
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.