FILTER IN LOADING SCRIPT WHERE EXISTS ?

[philgood34]

Hi

i try to select datas during the loading script and i read several threads about "Where exists" (qlik view) but i don't no if it's possible with qlik sense and how

here is my issue :

tab 1

NCL     LIB

A         SECTOR 1

B          SECTOR 2

C          SECTOR 3

tab 2

tab2_NCL      SALES

A                    12

B                    24

C                    10

D                    36

E ....     ....

tab 3

tab3_NCL      margin

A                    5

B                    8

C                    8

D                    15

E ...     ...

in summary my script is :

tab1

load ncl as ncl-tab2_ncl,

load lib

FROM [lib://file.xls]

(biff, embedded labels, table is tab1);

tab2

load tab2_ncl as ncl-tab2_ncl,

load sales

FROM [lib://file.xls]

(biff, embedded labels, table is tab2);

tab3

load tab3_ncl as ncl-tab2_ncl,

load margin

FROM [lib://file.xls]

(biff, embedded labels, table is tab3);

What and where should I insert 

to load only A,B & C DATAS from the tab 2 & 3 ?

Thank's in advance

Philippe

[swuehl · Accepted solution]

Maybe

tab1:

load

ncl as ncl-tab2_ncl,

lib

FROM [lib://file.xls]

(biff, embedded labels, table is tab1);

tab2:

load

tab2_ncl as ncl-tab2_ncl,

sales

FROM [lib://file.xls]

(biff, embedded labels, table is tab2)

WHERE EXISTS(ncl-tab2_ncl, tab2_ncl) ;

tab3:

load

tab3_ncl as ncl-tab2_ncl,

margin

FROM [lib://file.xls]

(biff, embedded labels, table is tab3)

WHERE EXISTS(ncl-tab2_ncl, tab3_ncl);

[philgood34]

DATAS LOADED !

i'll test my vizualisations tomorrow and tell you

thank's

Philippe

[philgood34]

it's perfect !

very helpful for my data model

thank's a lot !