2 Replies Latest reply: Nov 1, 2018 2:30 PM by Justin Dallas RSS

    RecNo or RowNo to show duplicates ?

    Claudia Lettten

      Hi here is my script . This load contains duplicate rows and I need to display the duplicates in a table.

      Where do I place the RecNo ()   or RowNo ()  to do this ?

       

      [Table]:


      LOAD


      [Sales] ,

      [Order] ,

      [Total],

      [SortOrder] ,

         

      RESIDENT [Table];

      DROP TABLE [Table];



      RENAME TABLE  [Table] to [List];