4 Replies Latest reply: Nov 7, 2013 3:44 PM by Zach Paz RSS

    Changing a variable in one table to an updated status in another table

    Zach Paz

      Hello,

       

      Is there a way to update a variable/column in an existing QVD with a table that contains updates for that table.

       

      I have one QVD:

      Table1:

      ID     Status

      1     Converted

      2     Inquiry

      3     Inquiry

      4     Converted

      5     Inquiry

       

      And one update file:

      Table2:

      ID     Status

      2     Converted

      5     Converted

       

      I want Table1 to be updated to look like this:

      Table1:

      ID     Status

      1     Converted

      2     Converted

      3     Inquiry

      4     Converted

      5     Converted

       

      Where Table2 updates the records in Table1, but keeps the records in Table1 that do not have an update.

       

      Thanks in advance!