4 Replies Latest reply: Mar 3, 2017 4:02 PM by Nav Pienaar RSS

    Same Transcation, Same Person, Different Company

    Jia Sheng Loh

      Hello Experts all around the world!

       

      I need help to flag out Transaction with same bidder but different Company.

       

      TransactionBidder

      Company

      1001AAXYZ
      1001AAKID
      1004DDYOO
      1004DDYOO
      1005EEJOK
      1005EEJOK
      1005EEQID

       

      With above example data, 2 transaction (1001 ad 1005) will be flag out.

       

      Transaction 1001: Same bidder, Different Company :1

      Transacion 1004: Same bidder, Same company: 0

      Transaction 1005: Same bidder, Different Company: 1

       

      So my KPI count will be 2.

       

      I would prefer to have my expression to load in KPI expression instead of data load.

       

      Regards,

      Jia