5 Replies Latest reply: Aug 27, 2018 2:08 PM by Andrey Krylov RSS

    Creating a Counter Field by a Dimension

    Mark Perreault

      Hi All,


      I have the below Data

       

      IDSubID
      A2343242
      A6456456
      B7896957
      C2432645
      C4764576
      C3454352

       

      and id like to create a field in the script that would give me the below table

       

      IDSubIDID-Counter
      A2343242A - 1
      A6456456A - 2
      B7896957B - 1
      C2432645C - 1
      C4764576C - 2
      C3454352C - 3

       

       

      So it would be essentially

      ID & Autonumber(SubID)

      by the number of SubID's for ID

       

      Does anyone have any ideas?

       


      Thanks,

      Mark