Discussion board where members can get started with QlikView.
I'm newbie with Qlikview.
I can do this with SQL
SELECT x, y, 'OK' As STATUS FROM Table1 WHERE
EXISTS (SELECT * FROM Table2 WHERE x = t2x AND y = t2y AND tppr <>100)
EXISTS (SELECT * FROM Table3 WHERE x = t3x AND y = t3y AND ttpr <>100)
How can same be made with Qlikview LOAD RESIDENT clause? What i want to do is add one column in table1 with new status information
from table2.qvd (qvd) where x = 't2x' AND y =' t2y' AND tppr <>100;
from table3.qvd (qvd) where x = 't3x' AND y = 't3y' AND ttpr <>100;
from table1.qvd (qvd);
'OK' As STATUS
resident Table where (x = 't2x' AND y =' t2y' AND tppr <>100) or (x = 't3x' AND y = 't3y' AND ttpr <>100);
drop table Table;
Many thanks to you Erika, this was helpful