Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tricky exists thing

Hi Qlikviewgurus,

I came across many situations where exists behave weird specially in resident.

Can Someone pls explain me why I am not getting the value in tableB

Ideally,I want is matching record from tablea and tablec(temp tables) should be present in tableB,Since I am dropping the table going forward.

TableA:

LOAD * Inline

[

C1

A

B

C

W

];

TableC:

Load * Inline

[

C1,desc

W,hu

A,lo

];

TableB:

LOAD C1 as C1_new

RESIDENT TableA

Where Exists(C1_new,C1);

Drop table TableA;

Drop table TableC;

12 Replies
sunny_talwar

It is this script:

TableA:

LOAD * Inline

[

C1_new

A

B

C

W

];

TableC:

Load * Inline

[

C1,desc

W,hu

A,lo

];

TableB:

NoConcatenate

LOAD C1_new

RESIDENT TableA

Where Exists(C1, C1_new);

Drop table TableA;

Drop table TableC;

Output I get is this:

Capture.PNG

Anonymous
Not applicable
Author

Hi Manuel,Can you please explain me in detail what u meant.

Table A comprises of A,B,C,W values for C1 Column.

Table C comprises of A,W values for C1 Column.

when table B starts executing it should make C1 column of Table to C1_new column and compare the existing values with the C1 which should give me the result.

Pls correct my understandiing and logic.

Anonymous
Not applicable
Author

TableA:

LOAD * Inline

[

C1

A

B

C

W

];

TableC:

Load * Inline

[

C1,desc

W,hu

A,lo

];

TableB:

LOAD C1 as C1_new

RESIDENT TableA

Where Exists(C1);

Drop table TableA;

Drop table TableC;

this approach records all the data in table B but our condition is just matching records.Kindly correct me