Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
vikasmahajan
Honored Contributor III

doubts about apply map

Dear all

here apply map allows us to take one primary key and value while loading data into qlikview for e.g following code

map1:
mapping load * inline [

ID, Textvalue

1, one

2, two

3, three ] ;

ApplyMap ( 'map1', 1, 'xxx' ) It will return 'one'

ApplyMap ( 'map1', 2 ) It will return 'two'


ApplyMap ( 'map1', 4 ) It will return 4


ApplyMap ( 'map1', 5, 'No result' ) It will returns No result

---------------------------------------------------------------

But whether it is possible to put composite key in while loading applymap  for e.g    I have field  SalesGrp+HQID

and its targets then whether it is possible to load with composite key (salesgrp+hqid) in apply map ?

Thanks in adv.

Vikas

3 Replies
forte
New Contributor III

Re: doubts about apply map

Hi Vikas :

As you can guess from the manual, a mapping load only consider two fields. One is the key and the other the value as you have explained perfectly.

If you need a composite key just create it concatenating both fields in order to create an unique key. For example yo can create Salesgrp & ' .. ' & Hqrd.

Hope that helps.

Best regards

er_mohit
Honored Contributor II

Re: doubts about apply map

no you can't do this through applymap

it based on primary key

but for that you can create a field  SalesGrp &'-' &HQID as Primary

and use that field and on above side write field there it become easier for matching and if values doesn't match then

the same value it is coming or you make it null also like


ApplyMap ( 'map1', ID, '#N/A' ) It will return matching data with name and else #N/A


vikasmahajan
Honored Contributor III

Re: doubts about apply map

Thanks I will try the same I think I guess the same.

Vikas