2 Replies Latest reply: Dec 4, 2012 5:27 PM by mhalvorson RSS

    Updating a record in a table in script - new to QlikView

      Hi

       

      I am new to QlikView and also new to SQL.

       

      I have the following code which updates the 'debtor' table:

       

      Inner join(debtor)

      LOAD "s-order",

          upper ("sorder-category") as "sorder-category";

      SQL SELECT "s-order",

          "sorder-category"

      FROM PUB.sorder;

       

      How do I now update one of the other fields in the 'debtor' table based on the results from this code above?

       

       

      Thanks