3 Replies Latest reply: Feb 13, 2012 11:56 AM by lmuruarogue RSS

    adding a new value to a field

      hello

      I'm trying to add two additional values to a field when loading "service as Cost_activity."  the field only has 3 values (A, B, C) for cost_activity.  I want to add in the script "D" and "E" as values which do not currently exisit in the source table.  how do a I add them?
      LOAD

      id as service_id,
      service as cost_activity,


      SQL SELECT *
      FROM service;