topic Re: WHAT IS OUTPUT FOR THIS in QlikView

WHAT IS OUTPUT FOR THIS

Sat, 08 Feb 2014 19:36:25 GMT

tab1:

LOAD * INLINE [

F1, F2

A, 1

B, 2

C, 3

D, 4

];

tab2:

LOAD * INLINE [

F3, F4

A, AA

B, BB

C, CC

E, EE

];

Table3:

LOAD

RESIDENT tab2

WHERE Exists(F1,F3);

drop table tab1;

drop table tab2;

Re: WHAT IS OUTPUT FOR THIS

Peter_Cammaert — Sat, 08 Feb 2014 19:40:29 GMT

Lines with F3 = {A,B,C} and corresponding F4 values will exist in Table3;

Peter

Re: WHAT IS OUTPUT FOR THIS

Peter_Cammaert — Sat, 08 Feb 2014 19:42:22 GMT

But why don't you just run the script and open the table viewer? QlikView is the magical trial-and-maybe-but-you-never-know-error tool!

Peter

Re: WHAT IS OUTPUT FOR THIS

Sat, 08 Feb 2014 19:42:44 GMT

hi peter pls calrify me what is the difference between exists and not exists function

Re: WHAT IS OUTPUT FOR THIS

Peter_Cammaert — Sat, 08 Feb 2014 19:44:25 GMT

Of course, it may be that Table3 gets JOINed to tab2 and dropped in the end... Add NOCONCATENATE to the Table3 LOAD to be sure.

Peter

Re: WHAT IS OUTPUT FOR THIS

maxgro — Sat, 08 Feb 2014 19:44:29 GMT

the result is nothing

if you want table 3 as result you must add a noconcatenate

Table3:

noconcatenate

LOAD

RESIDENT tab2

WHERE Exists(F1,F3);

Re: WHAT IS OUTPUT FOR THIS

Peter_Cammaert — Sat, 08 Feb 2014 19:48:18 GMT

It's the same function: exists(). In the second case, you are logically negating the return value of exists(). NOT is a boolean operator that says that exists() should not return true.

...WHERE Not Exists(F1, F3);

means that each F3 value we are loading should NOT exist in field F1.

Peter

Re: WHAT IS OUTPUT FOR THIS

Sat, 08 Feb 2014 19:48:21 GMT

hi i want know how exist function work here can u pls explain me

Re: WHAT IS OUTPUT FOR THIS

Peter_Cammaert — Sat, 08 Feb 2014 19:54:54 GMT

For every row we load from table tab2, QlikView checks whether the value in column F3 exists in the existing QlikView field F1. It sort of acts like a lookup. If the value exists, the row will be stored in table Table3. Otherwise the row will be dropped.

Peter

Sorry, corrected naming error

Re: WHAT IS OUTPUT FOR THIS

Sat, 08 Feb 2014 19:58:37 GMT

thanks

Re: WHAT IS OUTPUT FOR THIS

Sat, 08 Feb 2014 20:03:42 GMT

tab1:

LOAD * INLINE [

F1, F2

A, 1

B, 2

C, 3

D, 4

];

tab2:

LOAD * INLINE

[

F3, F4

A, AA

B, BB- -----------------------WHY WE CANNOT USE THIS 2 TABLES PETER

C, CC

E, EE

]

WHERE Exists(F1,F3);