8 Replies Latest reply: May 13, 2013 10:00 AM by Rob Wunderlich RSS

    Running count of the Filed in the Script

    Srikanth P

      Hi Folks,


      I am trying to attach the running count of the filed in the script. Please find the below sample example:


      ID Sales

      A  100,250

      B  390

      C  30,345,360


      I want load the above table into below:


      ID Sales Running_Cnt

      A  100      1

      A  250      2

      B  390      1

      C  30        1

      C  345      2

      C  360      3


      I created the Sales by using subfield(Sales,','), but I am unable to attach the Running_Cnt to the table.


      Please find the attched application.



      Thanks & Regards,