Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am pulling data from a SQL database into Qlikview and attempting to Apply a Mapping.
ErrorSource: Microsoft SQL Server Native Client 11.0, ErrorMsg: 'ApplyMap' is not a recognized built-in function name.
I'm guessing this message is because I am attempting to use 'ApplyMap' in the select statement and it is not a SQL function. Does someone know of another way to accomplish this?
Thank You
You can use a preceding LOAD statement:
LOAD
FIELD,
ApplyMap('MAP', FIELD, 'No Map found') as MappedField;
SELECT FIELD FROM ...;
In the SQL codes(where you connect Qlik to your DB) itself, you can't use applymap. use after you pull the tables.
Try doing it in the LOAD statement (preceding load) to use ApplyMap because ApplyMap is a QlikView function.
You can use a preceding LOAD statement:
LOAD
FIELD,
ApplyMap('MAP', FIELD, 'No Map found') as MappedField;
SELECT FIELD FROM ...;
The Preceding load worked but my following SELECT statement did not pull in the rest of the data,
LOAD
FIELD,
ApplyMap('MAP', FIELD, 'No Map found') as MappedField;
SELECT FIELD, Field2, field3,
FROM ...;
I only get the MAP and FIELD.
O think I'm on the right track though. thanks,
if you want also the other 2 fields, add the 2 fields to the load (in bold)
LOAD
FIELD,
Field2, field3,
ApplyMap('MAP', FIELD, 'No Map found') as MappedField;
SELECT FIELD, Field2, field3,
FROM ...;
Thank you all. Very helpful!