Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load Resident if Exists

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)

OR

          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

2 Replies
Not applicable

Load Resident if Exists

Try This:

Table:

Load

x,

y,

tppr

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

concatenate

Load

x,

y,

ttpr

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

concatenate

Load

x,

y

from table1.qvd (qvd);

TableFinal:

Load

x,

y,

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

Not applicable

Load Resident if Exists

Many thanks to you Erika, this was helpful

Community Browser