Discussion Board for collaboration related to Creating Analytics for QlikView.
I need to map all those starting by Status_description AP001 to the status code AP001.
AP001 THUR AP001
AP001 ERTD AP001
AP001 PLYT AP001
So I created a Mapping as below:
Mapping load * inline [
AP001* , AP001
But it does not work.
I think it will be down to the '*', not sure it is works with the wildcard in a mapping.
What is it your trying to do?
Have you thought about mapping usign the subfield() function.
SUBFIELD(Status_description,' ',1) as Status_Code
Mapping doesn't work with wildcards. Try with WildMatch(), like:
if(WildMatch(Field, 'AP0001*') , 'AP0001' , Field) as NewField
Or, even try with MapSubstring(). You may refer: Re: Wildcard when ApplyMap
Like useful compare the fields
Try somthing like?
Where/IF Status_Description like 'AP001*'
if(left(Status_Description,5) = 'AP001','AP001') AS status_code