I have table created from SQL query in the script , I want to add an extra column in this table , this column is based on Previous function in Qlikview , bellow is an example
Order:
SQL
Select Col1,Col2
FROM
Order;
I want to add below third column in Order table inside script so final table should have three columns
When you load a resident table with a previous statement, and you order your table at the same load statement, previous don't works as expected, because order by is done later than previous, peek is calculated after order.
As elegant as the preceding load looks, my solution seems the simplest...and works. BTW, I did forget one comma after Col2 in the resident load, so the code should look like
Right Manuel, but Tamil's does, and is to what I was referring to. I responded to the wrong suggested solution...sorry about that. Your solution indeed looks simpler, but is a left join more efficient than my solution, especially for large data sets?
