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.

     

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.