tricky exists thing

[Anonymous]

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;

[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:

[Anonymous]

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]

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