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,

      Srikanth