Discussion Board for collaboration on QlikView Scripting.
When I am trying to map a table, it is only converting the label/column title and not the data in the fields below? has anyone seen this issue before?
Is it possible to share a small sample file?
can give you the general template:
(biff, embedded labels, table is [sheet1$]
Rename FIELDS USING MAPPINGTABLE;
Do I need to use applymap?
I don't really understand where to put the function though, as it seems to not work on the correct table
check your spelling /case sensetive . That is usually the issue.
I am not sure what exactly you are trying to do based on the sample you provided. Have you taken a look at the help. In help you have examples, so that you can understand better,
You have correctly created the mapping table. The particular way you are using the mapping table:
Rename FIELDS USING MAPPINGTABLE
will rename field names, it does not change field contents.
If you want to change the contents (values) of a field, use either the MAP statement or the ApplyMap function.
For example, to change the map value in the Customer field:
MAP Customer USING MAPPINGTABLE;
Place the MAP statement in the script before the Customer table is loaded.
To map values as they are loaded, use the ApplyMap() function in a load statement.
ApplyMap('MAPPINGTABLE', Customer) as Customer