Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
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);
Hi,
use where exists()
REF:
LOAD ID ,
AREA,
NAME,
DEPT_LEVEL,
DEPT_PARENT
FROM
(ooxml, embedded labels, table is Feuil1)
where exists(ENTITE,NAME)
;
Thank you sunny
But dreamer4 this would check for NAME against both Region_Zone table and Zone table... Not sure if this is what souadouert wants
thank you
Actually I did not gone through her entire script.
I just gave her logic and function which she is looking for.
Regards,