topic Re: applymap in QlikView

applymap

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,
I am a new member on Qlik view ,I have some errors when I apply the ApplyMap () function between my two tables knowing that I renamed the common key to have the same name in both tables.

it tells me that my field can not be found.

Thank you for your help.

Re: applymap

sunny_talwar — Fri, 28 Apr 2017 13:54:22 GMT

Can you share the script you have used?

Re: applymap

ziadm — Fri, 28 Apr 2017 13:56:08 GMT

Please post a sample code

The Syntax

ApplyMap('TableName',FieldName,'Unknown') as MappedField

You must be passing a FieldName that is does not exist in the Table

Re: applymap

Anonymous — Fri, 28 Apr 2017 14:05:46 GMT

Re: applymap

Anonymous — Fri, 28 Apr 2017 14:09:13 GMT

Attached the screenshot of my script .

Thank you for your help.

Re: applymap

sunny_talwar — Fri, 28 Apr 2017 15:26:08 GMT

You need to move Progress tab before Defect because the mapping table load needs to be before you use ApplyMap

Re: applymap

Anonymous — Fri, 28 Apr 2017 15:35:18 GMT

I have this error:

Re: applymap

sunny_talwar — Fri, 28 Apr 2017 16:13:54 GMT

replace KeyDefectStatus with Site&DefectStatus within the ApplyMap line

Re: applymap

Anonymous — Fri, 28 Apr 2017 16:24:39 GMT

if I understand correctly, ApplyMap does not like renaming attributes?

Re: applymap

vishsaggi — Fri, 28 Apr 2017 16:29:31 GMT

Just an idea we can also do a preceding Load apply map If i am not wrong like:

LOAD *,

ApplyMap('Apply_Progress_Status', KeyDefectStatus) AS DefectStatusDesc;

LOAD DISTINCT

column1,

column2,

Site&DefectStatus as KeyDefectStatus,

Site

FROM ...... Defect-*.qvd(qvd);

Re: applymap

Anonymous — Tue, 02 May 2017 09:25:22 GMT

Thank you for your help.
I tried what you told me but unfortunately it doesn't take into consideration my ApplyMap, It loads just the columns of my table DEFECT.