In a data transformation, when creating a "set" action, I have a value that looks like this:
..If(..NotIn(source.Records.(k1).Property4,"Learn & Dev Supervisor,Director of Learn & Dev, Clinical Trainer Lead, Learning and Development Specialist Lead"),"TL","3")
Is there a way to target keywords such as "Trainer", or "Learning" so I don't have to keep adding specific job titles?
Similar to a LIKE statement in SQL, if that makes sense.