6 Replies Latest reply: Mar 23, 2016 7:26 AM by Santosh Roy RSS

    Need help to get count in Script

    Santosh Roy

      hi,

       

      Please help me sort this,

       

      i want to get the column in script which will show nos of amendment per material, please guide me to do it.

       

      Data base

       

      Amendment no          po number     material

      1121                         55221100     abc123

      1122                         55221100     abc123

      1123                         55221100     abc123

      1234                         55331100     xyz123

      2132                         45421121     pqr234

      2133                         45421121     pqr234

      2134                         45421121     pqr234

      2135                         45421121     pqr234

      2136                         45421121     pqr234

       

       

      What i want column in script to get count of nos of amendment per material

       

       

      Amendment no          po number     material     Count

      1121                         55221100     abc123           1

       

      1122                         55221100     abc123           1

      1123                         55221100     abc123           2


      1234                         55331100     xyz123           1


      2132                         45421121     pqr234            1

      2133                         45421121     pqr234             2

      2134                         45421121     pqr234             3

      2135                         45421121     pqr234             4

      2136                         45421121     pqr234             5



      Thanks in advance.