Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to Select rows that has same value for certain columns, and different value for one column

Hello !

I am in a trouble finding a calculated column or measure that Select every rows that has the same value for the 3 columns Bank account, info 1 & info 2 AND when the Supplier is different (it shouldn't happen, thats why I want to detect these anomalies). To make it more clear, here is an example of what I should have with my measure:

Supplier     Bank account   info 1      info 2
A1000FranceEnergy
B1000FranceEnergy
C1000ChinaOil
A1000FranceGaz


The query should return these rows because these 2 suppliers have the same bank account number and same informations (this is an anomaly):

Supplier   Bank account        info 1    info2      
A1000FranceEnergy
B1000FranceEnergy

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you it works,

      I have another question, do you know how to do the contrary, like one supplier has several lines that aren't composed of the same informations ?
      Here it would show the two lines about supplier A:

      Supplier     Bank account   info 1      info 2
      A1000FranceEnergy
      A1000FranceGaz
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Jihwan_Kim 

       

      I have an issue with this query when I have more than around 5000 rows, it takes too much time and it ends up with a "Memory error, try again when you have more memory available".

       

      Do you know how can I solve this problem ?

       

      Thank you !