Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

exists function pls apply it for this tables

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

1 Solution

Accepted Solutions
Nicole-Smith
Not applicable

Re: 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

(ooxml, embedded labels, table is Sheet2)

where exists(id);

6 Replies
Nicole-Smith
Not applicable

Re: 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

(ooxml, embedded labels, table is Sheet2)

where exists(id);

swuehl
Not applicable

Re: exists function pls apply it for this tables

tab2:

LOAD id,

     a,

     b,

     c

FROM

exists.xlsx 

(ooxml, embedded labels, table is Sheet2)

where exists(id);

Not applicable

Re: exists function pls apply it for this tables

GRAND SUCESS THANK U

Not applicable

Re: exists function pls apply it for this tables

GRAND SUCESS THANK U

Nicole-Smith
Not applicable

Re: exists function pls apply it for this tables

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

Not applicable

Re: exists function pls apply it for this tables

for not exists also its showing same fields