Question
Dustin Knudsen · Jul 27

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
00
1 0 2 60
Log in or sign up to continue

As an alternate approach, you could use the Lookup() function to check if the value exists in a lookup table. The advantage is that adding entries to a lookup table is easier/cleaner than updating your DTL with every new entry.