DSXchange

Hi. Sorry, my wrong. The example is: Condition: (LnkFix.Customer_Name > 0) Or (LnkFix.Customer_Mail > 0) <-- are not working Condition Not Met: Reject Lookup Failure: Reject The thing I want to do is filter a record as invalid if it matches either of the two keys in the lookup. For example; In the p...

I need to compare 2 fields in the same file and reject the records were exists at least in one of the two validations:

Condition:
(LnkFix.Customer_Name > 0) Or (LnkFix.Customer_Name > 0) <-- are not working
Condition Not Met: Reject
Lookup Failure: Reject

Thanks in advance for your help.

Hi forum.
If exists the Not Like function in DS Used thru Filter o transformer stage
Example; columnA Not Like '%test%' or columnB not like '%bademail.com%'

Or probably any other stage from data quality

Thanks in advance