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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

WHAT IS OUTPUT FOR THIS

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;

Labels (1)
10 Replies
Not applicable
Author

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