We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Finding Patterns and Creating column

sriniprad08
11 - Bolide

Hi Team,

Hope you are well.

i need help. Please find below and let me know how to go about this.

 

Thanks

sriniprad08_0-1679666267803.png

 

15 REPLIES 15
binuacs
21 - Polaris

@sriniprad08 use the StartsWith() function 

 

IIF(StartsWith(]input],’CZL’),’CZL’,IIF(StartsWith(]input],’CXL’),’CXL‘,’ZZZ Contract’))

sriniprad08
11 - Bolide

Thank you @binuacs  This is great. But one challenge there are many other values inside that column other than what i listed.

so ideally it will classify everything else apart from cxl as zzz contract. 

ideally it has identify the pattern of the zzz contract and tag them. Remaining as others.

binuacs
21 - Polaris

@sriniprad08 if the string has -S or -P then can it be considered as ZZZ contract? Or any other pattern should follow

sriniprad08
11 - Bolide

Thanks @binuacs  Please find below

The marked in Red has no -S or -P but still its a zzz contract.

the one marked in yellow has shorter length than the black one. it will be zzz contract.

sriniprad08_0-1679674449070.png

 

binuacs
21 - Polaris

@sriniprad08 try the attached workflow

binuacs_0-1679684016524.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

Great. Thank you. Appreciate it.

Labels
Top Solution Authors