topic Load Resident if Exists in QlikView

Load Resident if Exists

Thu, 19 May 2011 08:14:20 GMT

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

Thu, 19 May 2011 09:53:25 GMT

Try This:

Table:

Load

tppr

from table2.qvd (qvd) where x = 't2x' AND y =' t2y' AND tppr <>100;

concatenate

Load

ttpr

from table3.qvd (qvd) where x = 't3x' AND y = 't3y' AND ttpr <>100;

concatenate

Load

from table1.qvd (qvd);

TableFinal:

Load

'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;

Thu, 19 May 2011 13:04:20 GMT

Many thanks to you Erika, this was helpful