7 Replies Latest reply: Jun 25, 2015 8:29 AM by Kranthikumar Miryala RSS

    Delete dublicate rows in script

    Андрей Шепель

      Good day!

       

      In load script i have such table:

       

      Table:

      load rowno(),

      Id,

      Name

      from Source...

       

       

      rowno()IdName
      11Name1
      21Name1
      31Name2
      42Name1
      52Name1
      62Name1
      72Name1
      82Name1

       

       

      How to delete in load script dublicate rows, where Id and Name have the same value?

      I need get such table:

       

       

      rowno()IdName
      11Name1
      21Name2
      32Name1

       

       

      Thx.