6 Replies Latest reply: Aug 29, 2018 10:53 AM by Przemyslaw Rybacki RSS

    Selecting one of the doubled values

    Przemyslaw Rybacki

      Hello All,

       

      Is there any expression in Data Load Editor  where I can select one of doubled values?  

       

         

      UserORDER IDDATEQTY
      AUTO10345921-8-20182
      XYZ10345921-8-20182
      AUTO10344821-8-20182
      AUTO10346321-8-20181
      XYZ10378921-8-20185
      AUTO10123521-8-20183
      XYZ10853121-8-20181
      AUTO10694121-8-20184
      XYZ10264821-8-20188

       


      In this case I need only amount of unites done by USER: XYZ.

      So In case where two users appears for the same order I need last occurred transaction.

       

      Greetings

       

      P.Rybacki