Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Comparing tables

Hello All,     I have a model as shown and am trying to get some  discrepency out here. The Buyers and Supplier is connected through the Buyer Number The Supplier and Orders are connected ...
Need Help
  • MikeJohnsonZA's avatar
    MikeJohnsonZA
    5 years ago

    I've simulated that scenario in order 10 and I do get the buyer mismatch, can you share a screenshot.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

MikeJohnsonZA  Thanks a lot.I tried and it worked but now i get another issue with data.

I have Buyers C and D.C is linked to Supplier 5 in the Supplier table but we have Order with D and this does not show up.

 

Thanks

MikeJohnsonZA's avatar
MikeJohnsonZA
Responsive Resident
5 years ago

I've simulated that scenario in order 10 and I do get the buyer mismatch, can you share a screenshot.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MikeJohnsonZA  Thanks. my mistake i was filtering with the wrong buyer.I just had a slicer wih the Buyer and was selecting the wrong one.But now it seems i go into more trouble.

    The discrepency in data becomes more visible.I have Orders on a Buyer E but in the Suppliers table the supplier for example Supplier  6 is connected to Buyer F who is not there in the Buyer table.It returns a blank row in the Buyer name and number.Thanks a lot it serves my purpose.

     

    Is there a way i could put a column in the Order table for Mismatch and put it to Yes or No depending on if i find a matching combination of Supplier and Buyer Number in Order table and Supplier table? 

    • MikeJohnsonZA's avatar
      MikeJohnsonZA
      Responsive Resident
      5 years ago

      Sure

       

      You would create a calculated column in the Orders table then use something like

       

      Buyer is Mismatched = if([buyer Mismatched] = 1,"Yes","No")

       

      Just a general warning on that, try not to create too many calculated columns in your model, they make the model larger and slow down your refreshes.