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

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

Anonymous I couldn't implement this formula...

 

In this step by step I created a sales verifier, if it contains the customer code in the SELL VERIFY column it means that I sold a product to that customer. But I only need to sell one product to the customer, so... I wanted to remove the repeaters.

 

Sorry guys for the bad wording of my question, I'll improve!