Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Outer Left Join Power Query not returning joined matches

I am doing an outer left join in power query to bring a value from another table. Join is done fine even when i look at the table inside the cell is the value I want take a look a the image.  ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thaks for your answer. You can find the file here https://docs.google.com/spreadsheets/d/1IbweWkfPkAXU3yt-CJMu4vEA19vZXXME/edit?usp=sharing&ouid=104612261627157802886&rtpof=true&sd=true 

 

Please go to PowerQuery Table 'StockReposicion'. You will find the error in the last 2 steps. First the join and then when is expanded. What its seen inside the joined column that contains a table it looks fine. Then when expanded results are different.

 

Thanks for your help.

ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

I hope someone comes up with an explanation.

It doesn't seem to matter what kind of Join you specify; they all seem to work OK with regard to the resultant table, but then provide the incorrect results for both tables when you expand them.

 

Of interest is that if you do a Table.Join (not nested), the result is what it should be.  So the following modification would work:

 

...
    #"Consultas combinadas1" = Table.Join(#"Filas filtradas3", {"Ubicacion"}, Layout, {"DescripciĆ³n"},  
        JoinKind.LeftOuter),
    #"Removed Columns" = Table.RemoveColumns(#"Consultas combinadas1",{"DescripciĆ³n", "Sector", "Nivel"})
in
    #"Removed Columns"

 

producing: