4 Replies Latest reply: Feb 9, 2017 12:22 AM by Rahul Pawar RSS

    Scripting-Is it possible to replace values of one table with another table

    vivek pv

      Hi Experts,

      I want to replace the values in table with the values in another table.

      my first table is loading with SQL Query with select statement and 2nd table is loading with Excel.

       

      Table1:

      select filed1,

      field2,

      0 AS NAME,

      100 AS NUMBER,

      '-' AS GROUP

      from TEST;

       

      Table2:

      LOAD

      NAME,

      NUMBER,

      GROUP

      from V2.xlsx

       

      In Table1, NAME, NUMBER, GROUP are hard-coded values. but in Table2, NAME, NUMBER, GROUP are having different values.

      now I want to replace these values in Table1 with the values in Table2.