topic Re: Mapping Table Issue in QlikView

Mapping Table Issue

Wed, 13 Jul 2016 15:58:24 GMT

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?

Thanks

Re: Mapping Table Issue

trdandamudi — Wed, 13 Jul 2016 16:02:15 GMT

Is it possible to share a small sample file?

Re: Mapping Table Issue

Wed, 13 Jul 2016 16:05:46 GMT

can give you the general template:

MAPPINGTABLE:

MAPPING LOAD

'existing'

'desired'

FROM 'file.xls'

(biff, embedded labels, table is [sheet1$]

Rename FIELDS USING MAPPINGTABLE;

Re: Mapping Table Issue

Wed, 13 Jul 2016 16:06:41 GMT

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

Re: Mapping Table Issue

alexpanjhc — Wed, 13 Jul 2016 16:12:16 GMT

check your spelling /case sensetive . That is usually the issue.

Re: Mapping Table Issue

trdandamudi — Wed, 13 Jul 2016 18:47:33 GMT

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,

Re: Mapping Table Issue

rwunderlich — Wed, 13 Jul 2016 19:29:56 GMT

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.

LOAD

id,

City,

ApplyMap('MAPPINGTABLE', Customer) as Customer

FROM xyz.xls....

-Rob

http://masterssummit.com

http://qlikviewcookbook.com