4 Replies Latest reply: Mar 17, 2016 5:57 AM by Emmanuel Damiano RSS

    Reload only one field in script table?

    Emmanuel Damiano

      Hello,

       

      I'm looking for a way, in the script, to reload only one field of a table that has already been alimented.

       

      Example:

      I want to have all the rows from SOURCE1 and from SOURCE2, and match them if possible (if not, leave the field Batch_Type or Batch_Ext_Code empty).

       

      BATCH:

      LOAD

           Batch_Id,

           Batch_Type

      from SOURCE1;

       

      OUTER JOIN

      LOAD

           Batch_Id,

           Batch_Ext_Code

      from SOURCE2;

       

      After that load, I would like to replace the null values in Batch_Type field by 'Not Defined', without having to reload the entire content of the table into another table.

       

      Is there a way to do so?

      If you want more details, it's because I need afterwards to remove some rows in some parts of the UI thanks to set analyses based on some values of Batch_Type (Batch_Type -= {xxx}), and unfortunately this also removes the rows with null values.

       

      Many thanks in advance

       

      Emmanuel