7 Replies Latest reply: Oct 30, 2015 9:05 AM by Andrew Houston-Floyd RSS

    Create new rows from existing records

    Andrew Houston-Floyd

      Hi everyone,

       

      I don't know if this possible - I think it is.

       

      I have an existing dataset that looks like this:

       

       

      IDMarketAmount
      H91Product$100
      B475DService$150
      XH1Other$75
      AB85Modeled$200

       

      I want to take all IDs within Market = 'Modeled' and break them out into multiple new IDs using this breakout table:

        

      Market%Breakdown
      Product50%
      Service30%
      Other20%

       

      The result would look like this:

       

      IDMarketAmount
      H91Product$100
      B475DService$150
      XH1Other$75
      AB85_1Product$100
      AB85_2Service$60
      AB85_3Other$40

       

      If it's not possible to add an underscore + number to ID, that's fine.

       

      Does anyone know how to do this in the script? Or even in an object if necessary?