exists function pls apply it for this tables

[#1]

exists function pls apply it for this tables

tab1:

LOAD id,

     a,

     c,

     f,

     g

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet1);

tab2:

LOAD id,

     a,

     b,

     c

FROM

exists.xlsx  where exists(id);

(ooxml, embedded labels, table is Sheet2);

PLS MAKE THIS SCRIPT CORRECT BY USING EXISTS FUNCTION .I AM Q QLIKVIEW LEARNER PLS..........................

WHERE TO WRITE SYNTAX CORRECTLY

[Nicole-Smith · Accepted solution]

tab1:

LOAD id,

     a,

     c,

     f,

     g

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet1);

tab2:

LOAD id,

     a,

     b,

     c

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet2)

where exists(id);

[swuehl]

tab2:

LOAD id,

     a,

     b,

     c

FROM

exists.xlsx 

(ooxml, embedded labels, table is Sheet2)

where exists(id);

[#4]

GRAND SUCESS THANK U

[#5]

GRAND SUCESS THANK U

[Nicole-Smith]

Please mark helpful and correct answers so others can find answers to their problems too

[#7]

for not exists also its showing same fields