Power Query - Rows from 1st table in left outer join disappear after expand step where I remove the matching column

[PM1985]

Dear experts,

I am new in Power Query,

I am doing a left join based on 1st table "INPUT LFB1 KNB1" and second table "Input LFBK/KNBK" based on matching column "LIFNR/KUNR".

After 1st step everything seems fine:

But then I want to remove the LIFNR/KUNNR from second table and expand the rest:

And then the first rows disappear, namely the ones which did not have entries in second table:

This does not make any sense for me since it is a left join, so it should keep all rows from 1st table

This is the generated code

I thank you very much for any tip on this issue.

Thanks a lot.
Pedro

 

[Alex Blakenburg]

Just curious, have you done a record count ?
Are you sure it is not just the sort order that has changed and the rows are still there just not at the top ?

 

[PM1985]

Hello Alex,

you are right, for some reason it puts the rows in the bottom for which the left join did not add items from 2nd table. It is strange behavior for me, but the puzzle is solved

thanks a lot.
Pedro

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.