topic applymap in QlikView

applymap

souadouert — Thu, 16 Nov 2017 14:03:44 GMT

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 — Thu, 16 Nov 2017 14:23:26 GMT

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

sunny_talwar — Thu, 16 Nov 2017 14:27:08 GMT

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

souadouert — Fri, 17 Nov 2017 08:14:31 GMT

thany y youssef

souadouert — Fri, 17 Nov 2017 08:17:25 GMT

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