Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
REF_ENTITY:
LOAD ID ,
AREA,
upper(Replace(NAME,'DIR. REGION.','DIRECTION REGIONALE')) AS Libellé,
DEPT_LEVEL,
DEPT_PARENT as code_entité_mère
FROM
(ooxml, embedded labels, table is Feuil1)
where
/*exists(ENTITE, upper(Replace(NAME,'DIR. REGION.','DIRECTION REGIONALE'))) */
(DEPT_LEVEL='40' and DEPT_PARENT='506')or DEPT_LEVEL='80' or DEPT_LEVEL='90' or ID=506 or ID=500 ;
REF_Final:
load
ID,
upper(Replace(NAME,'DIR. REGION.','DIRECTION REGIONALE')) AS Libellé,
DEPT_LEVEL,
DEPT_PARENT as code_entité_mère ,
ApplyMap('REF_ENTITY',ID,null()) as entité_mère
FROM
(ooxml, embedded labels, table is Feuil1)
where
/*exists(ENTITE, upper(Replace(NAME,'DIR. REGION.','DIRECTION REGIONALE'))) */
(DEPT_LEVEL='40' and DEPT_PARENT='506')or DEPT_LEVEL='80' or DEPT_LEVEL='90' or ID=506 or ID=500 ;
drop table REF_ENTITY;
i need to extract the NAME of code_entité_mère , i tried this script but always entité_mère nul
Applymap() works only with Mapping load table
you need to create another table (mapping table) and load the ID and the name before the Applymap()
Applymap() works only with Mapping load table
you need to create another table (mapping table) and load the ID and the name before the Applymap()
You have used REF_ENTITY in your ApplyMap, but REF_ENTITY is not a Mapping Table?
thany y youssef
Hello SUNNY I misapplied the function apply but now i changed the script