I merge two tables with left outer join and it is bringing false result.
Here is my example:
I have a dummy "Table" with one row that I merge with table "Payment data" to get the value date.
Payment data table originally had duplicated rows and I kept only those lines that had the latest Value date. For the example I additionally filtered it down to the only one row that I would like to see in the result after the merge (as you can see on the screenshot).
Making the merge I am getting a result where the value date is 16/01/2020 (instead of 22/01/2020) that I already filtered out long before from Payment data table.