5 Replies Latest reply: May 21, 2015 12:42 PM by Jason Willcox RSS

    How to count instances on load

    Jason Willcox

      Hi There

       

      I am loading several seperate datasets which all look something like this;

       

      CUSTOMER_idINFO
      0100A
      0200B
      0300C
      0200A
      0100B

       

      I am concatenating the datasets on load and once that is done I want the load script to assign a count to each CUSTOMER_id.

       

      So for the example above I would like to see this;

       

      CUSTOMER_idINFOCustomer_Count
      0100A2

      0200

      B2
      0300C1
      0200A2
      0100B

      2

       

      How can I set and store the count?

       

      Thanks

      JW