· Jul 27, 2021

Using key words in Data Transformation action?

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.

Product version: Ensemble 2018.1
Discussion (2)0
Log in or sign up to continue