3 Replies Latest reply on Oct 12, 2017 7:08 AM by Ib Christiansen

    Comparing # of unique records based on a column value.

    Ib Christiansen

      I have a dataset with Order_ID, Order_Date, Product_ID. The data is in one table but comes from two source systems, ASOURCE & ANOTHERSOURCE. I want to reconcile the data from both source systems so that I can display:

      * count of matching Order_ID, Order_Date, Product_ID in both sources

       

       

       

       

      The data looks like this:

      SourceOrder_IDOrder_DateProduct_ID
      ASOURCE12301.01.2015ABC
      ASOURCE12301.01.2015AABC
      ANOTHERSOURCE12301.01.2015ABC
      ANOTHERSOURCE12301.01.2015AABC
      ASOURCE12402.01.2015ABC
      ANOTHERSOURCE12202.01.2015ABC
      ASOURCE12503.01.2015ABC
      ASOURCE12503.01.2015AABC
      ANOTHERSOURCE12503.01.2015ABC
      ANOTHERSOURCE12503.01.2015CBA

       

       

       

      Output should look like this.

       

      Source# of matching records
      In both systems3
      In ANOTHERSOURCE only2
      In ASOURCE only2

       

       

      How should I attack this? Should I create a parameter(? - not sure if this is the right approach) or a calculated field (or both) to display this information? I'm having trouble defining the problem...

       

      Message was edited by: Ib Christiansen - Slight edit to make the language more precise.