Using key words in Data Transformation action?

Question

Question

Dustin Knudsen · Jul 27, 2021

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

Muhammad Waseem · Jul 27, 2021

Yes you can use functions like Contains() or SubString().

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

0 0

score 0 · Answer 1 · 2021-07-27T13:57:47-04:00

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.