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
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

That is indeed very bizarre behavior. I have no explanation for it but maybe Ben Gribaudo has.

 

I used an alternative code 

 

    #"Added Custom" = Table.AddColumn(#"Filas filtradas3", "Layout", (k)=> Table.SelectRows(Layout,each [Descripción]=k[Ubicacion])),
    #"Expanded Layout" = Table.ExpandTableColumn(#"Added Custom", "Layout", {"Código Id"}, {"Código Id"})
in
    #"Expanded Layout"

and that worked fine.