Like keyword in Alteryx

Hi,

I have to look up for words like 'abc-treatment' from a column which is a concat of multiple values ( eg 'abc-treatment/def-maintainence')

'abc-treatment/def-maintainence'- this should match

'def-treatment/abc-maintainence'- this shouldn't match

I am not sure about what function to use here

Thanks,

Accepted answers

I'm going to use examples with a SQL syntax for comparison to give you all three versions of the "Like Operator" as I would recommend in Alteryx

LIKE 'abc-treatment%' (start of string):

STARTSWITH([field],'abc-treatment')

LIKE '%abc-treatment%' (any part of string):

CONTAINS([field],'abc-treatment')

LIKE '%abc-treatment' (end of string):

ENDSWITH([field],'abc-treatment')

I hope this helps!

@Inactive User If it's at the beginning of your field, you can use an expression like

startswith([Field], 'abc-treatment')

It can be anywhere in middle or end as well ..

eg- > xyz-treatment/def-maintainence/abc-treatment

I'm going to use examples with a SQL syntax for comparison to give you all three versions of the "Like Operator" as I would recommend in Alteryx

LIKE 'abc-treatment%' (start of string):

STARTSWITH([field],'abc-treatment')

LIKE '%abc-treatment%' (any part of string):

CONTAINS([field],'abc-treatment')

LIKE '%abc-treatment' (end of string):

ENDSWITH([field],'abc-treatment')

I hope this helps!