Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
Why? It should not be like this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.