applymap

[Anonymous]

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.

[sunny_talwar]

Can you share the script you have used?

[ziadm]

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

[Anonymous]

[Anonymous]

Attached the screenshot of my script .

Thank you for your help.

[sunny_talwar]

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

[Anonymous]

I have this error:

[sunny_talwar · Accepted solution]

replace KeyDefectStatus with Site&DefectStatus within the ApplyMap line

[Anonymous]

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

[vishsaggi]

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