Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
replace KeyDefectStatus with Site&DefectStatus within the ApplyMap line
Can you share the script you have used?
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
Attached the screenshot of my script .
Thank you for your help.
You need to move Progress tab before Defect because the mapping table load needs to be before you use ApplyMap
I have this error:
replace KeyDefectStatus with Site&DefectStatus within the ApplyMap line
if I understand correctly, ApplyMap does not like renaming attributes?
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);