Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

applymap

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

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: applymap

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()

4 Replies
YoussefBelloum
Esteemed Contributor

Re: applymap

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()

Re: applymap

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

souadouert
Contributor III

Re: applymap

thany y youssef

souadouert
Contributor III

Re: applymap

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

Community Browser