5 Replies Latest reply: Jun 22, 2015 2:39 PM by Андрей Шепель RSS

    Delete dublicate rows group by some field in loadscript

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

      Good day!

       

      In my model i have following fields:

      rowno(),

      Id,

      Name,

      Customer_id

      Main_field.

       

      My result table:

           

      rowno()IdNameCustomer_idMain_field
      122Name1196Main1
      222Name2196Main1
      322Name1196Main1
      422Name2197Main1

      What i need: Get result table, which has no dublicate rows by Customer_Id:

          

      rowno()IdNameMain_field
      122Name1Main1
      222Name2Main1

      Is it possible?

      Model and source file in attachment.

      Thanks.