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

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



      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",


      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?