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
Yes you can use functions like Contains() or SubString().
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
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.