Column expression with wild card pattern match

[rohinipe]

Hi All,

I’m trying to classify Purchase orders into different buckets based on certain pattern available in Input column string. How do I use Wildcard expression in Column expression node so as to get desired output?

Eg: Based on pattern in “PO Number” column, Im looking to have output in “PO type” column. I just displayed 5 rows, as an example. Actual table involves 50K+ rows.

Thank you in advance for help

[Daniel_Weikert]

You could use an if condition with regex matcher function to test a pattern and return your matching PO Type for each pattern you test
br

[rohinipe]

Hi @Daniel_Weikert ,

Thanks. Sorry im not so good at regex . Are you able to let me know how i should use regex matcher in column expression?

In above example, any PO that starts with 9 and has 6 digits, should give me an output

Also any PO that starts with REL followed by 4 digits should give me another output.

[Daniel_Weikert]

Hi @rohinipe
it is certainly easier if you upload sample data but in general here are matching examples you could try

br

[rohinipe]

Awesome this was super helpful. Thank you @Daniel_Weikert