6 Replies Latest reply: Nov 16, 2017 7:38 AM by Prashant Sangle RSS

    Where IN with qlikview

    souad ouertani

      Region_Zone:

      LOAD Code as Code,

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

          'région' as type_entite

      FROM

      [C:\Users\90160\Desktop\Vison360\entité\Nouveau dossier\Région_Zone.xlsx]

      (ooxml, embedded labels, table is Feuil1);

      Zone:

      LOAD Code as Code,

           UPPER(Zone) as ENTITE,

           'zone' as type_entite

      FROM

      [C:\Users\90160\Desktop\Vison360\entité\Nouveau dossier\Région_Zone.xlsx]

      (ooxml, embedded labels, table is Feuil2);

      REF:

      LOAD ID ,

           AREA,

          NAME,

           DEPT_LEVEL,

           DEPT_PARENT

          

      FROM

      [C:\Users\90160\Desktop\Vison360\entité\Classeur2.xlsx]

      (ooxml, embedded labels, table is Feuil1);

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