topic Re: exists function pls apply it for this tables in QlikView

exists function pls apply it for this tables

Thu, 06 Feb 2014 18:41:38 GMT

exists function pls apply it for this tables

tab1:

LOAD id,

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet1);

tab2:

LOAD id,

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 — Thu, 06 Feb 2014 18:42:31 GMT

tab1:

LOAD id,

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet1);

tab2:

LOAD id,

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet2)

where exists(id);

swuehl — Thu, 06 Feb 2014 18:43:40 GMT

tab2:

LOAD id,

FROM

exists.xlsx

(ooxml, embedded labels, table is Sheet2)

where exists(id);

Thu, 06 Feb 2014 18:57:20 GMT

GRAND SUCESS THANK U

Thu, 06 Feb 2014 18:57:30 GMT

GRAND SUCESS THANK U

Nicole-Smith — Thu, 06 Feb 2014 19:02:52 GMT

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

Thu, 06 Feb 2014 19:05:46 GMT

for not exists also its showing same fields