11 Replies Latest reply: May 25, 2015 5:47 AM by Sergey Pokasov RSS

    count of field values

    Kumar Pramod

      hi all,

       

      I have a table with two columns user_id and percentage_score in results table. I have attached the sample csv file.

       

      while loading the data i need to load user_id and count of each user_id.

       

      for example: user_id = 476 i have two times in table so i need count as 2.

       

      After loading table should look like below:

       

       

      User_idcount
      1241
      221
      321
      451
      572
      4762
      23
      771
      141
      233
      171
      4322

       

       

      Please note this i need this data while loading only.

       

       

      Thanks,

      Pramod