Where IN with qlikview

[souadouert]

Region_Zone:

LOAD Code as Code,

    upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE,

    'région' as type_entite

FROM

(ooxml, embedded labels, table is Feuil1);

Zone:

LOAD Code as Code,

     UPPER(Zone) as ENTITE,

     'zone' as type_entite

FROM

(ooxml, embedded labels, table is Feuil2);

REF:

LOAD ID ,

     AREA,

    NAME,

     DEPT_LEVEL,

     DEPT_PARENT

FROM

(ooxml, embedded labels, table is Feuil1);

so i need to add thius clause ->> where  NAME in (select ENTITE from region_zone )

[sunny_talwar]

May be try this

Region_Zone:

LOAD Code as Code,

    upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE,

   upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE_Check

    'région' as type_entite

FROM

(ooxml, embedded labels, table is Feuil1);

Zone:

LOAD Code as Code,

    UPPER(Zone) as ENTITE,

    'zone' as type_entite

FROM

(ooxml, embedded labels, table is Feuil2);

REF:

LOAD ID ,

    AREA,

    NAME,

    DEPT_LEVEL,

    DEPT_PARENT

FROM

(ooxml, embedded labels, table is Feuil1)

Where Exists(ENTITE_Check, NAME);

[PrashantSangle]

Hi,

use where exists()

REF:

LOAD ID ,

     AREA,

    NAME,

     DEPT_LEVEL,

     DEPT_PARENT   

FROM

(ooxml, embedded labels, table is Feuil1)

where exists(ENTITE,NAME)

;

[souadouert]

Thank you sunny    

[sunny_talwar]

But dreamer4‌ this would check for NAME against both Region_Zone table and Zone table... Not sure if this is what souadouert‌ wants

[souadouert]

thank you

[PrashantSangle]

Actually I did not gone through her entire script.

I just gave her logic and function which she is looking for.

Regards,