6 Replies Latest reply: Jun 13, 2016 10:10 AM by Stuart Frew RSS

    Flag Unique Customer IDs

    Stuart Frew

      Hi,

       

      I am loading some Customer IDs in from 2 seperate databases and I want to identify which Customer ID's are contained in each table and which are not.

       

      Hwo can I create flag script side so that I could correctly identify 1,3,5 as being duplicated but 2, 4 are not?

       

      Cus_ID
      1
      2
      3
      4
      5

       

      Cus_ID
      1
      3
      5

       

       

      Thanks

      Stuart