1 Reply Latest reply: Jun 21, 2017 3:42 AM by sasi k RSS

    Check Duplicate values in Column

    John Peter

      Hi,

       

      I have  a table with duplicate values in on column.

       

      I need to do some logic for duplicate records.

       

      this is my table

       

      ItemQtyCost
      Item11100
      Item11101
      Item11100
      item21200
      item32

      300

       

      This the Output i need. 

       

      ItemQtyCostDuplicateRevised Qty
      Item11100No1
      Item11101Yes0
      Item11100Yes0
      item21200No1
      item32300No2

       

      How to do this using load script or set analysis?

       

      Thanks,

      John.