I’m using a List Contain step to compare 2 tables based on 2 criteria with an AND operator and I believe the step is not working the way it should.
For what I understand, the List Contains compare 2 different tables and return only the records that match on both tables. With the AND operator you can compare multiple columns between these cables and will only get records one BOTH columns match. Correct?
So here’s what’s happening to me. I’m comparing 2 tables according to:
Table 1 (Date) = Table 2 (Werstellung) AND Table1 (Payee) = Table 2 (Beschreibung)
(don’t let the German names scare you ;)).
Here’s the setup:
However, the results are returning several records that don’t match the criteria. For example, I’m getting this record on the results where Date and Werstellung have different values.
Why is the List Contain returning this record as a result?