applymap

[souadouert]

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

[YoussefBelloum · Accepted solution]

Applymap() works only with Mapping load table

ApplyMap ‒ QlikView

you need to create another table (mapping table) and load the ID and the name before the Applymap()

[sunny_talwar]

You have used REF_ENTITY in your ApplyMap, but REF_ENTITY is not a Mapping Table?

[souadouert]

thany y youssef

[souadouert]

                   
Hello SUNNY I misapplied the function apply   but now i changed the script