Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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:
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.
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