Notice the OR condition where it check deactivation_date > transaction_date OR deactivation_date IS NULL
It would actually be something like:
IN_transaction_date as an input to the lookup.
How can I put the OR in a Lookup transformation?
Is this possible or is there anyway to work around this limitation?
I am trying to accomplish something like this:
activation_date <= transaction_date
(deactivation_date > transaction_date or
deactivation_date is null)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.