Forum Discussion

renatopnovaes's avatar
renatopnovaes
Icon for Helper I rankHelper I
5 years ago
Solved

Check another table

I'm setting up a conference between two tables. The target table and the sales table. I did a merge, I was able to say if the goal was completed or not. But if the seller sells the same product one m...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    As SELLOUT_D is your right table, in your join step, you can surround SELLOUT_D like this:

     

    Table.NestedJoin(#"Metas Julho", {"CLIENTE", "PRODUCTO"}, Table.Distinct(SELLOUT_D, {"CODIGO", BASE_SKU_GRUPO"}), {"CODIGO", BASE_SKU_GRUPO"}, "SELLOUT_D", JoinKind.LeftOuter)

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
5 years ago

As SELLOUT_D is your right table, in your join step, you can surround SELLOUT_D like this:

 

Table.NestedJoin(#"Metas Julho", {"CLIENTE", "PRODUCTO"}, Table.Distinct(SELLOUT_D, {"CODIGO", BASE_SKU_GRUPO"}), {"CODIGO", BASE_SKU_GRUPO"}, "SELLOUT_D", JoinKind.LeftOuter)

 

--Nate