doubts about apply map

[vikasmahajan]

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

[forte]

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]

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]

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

Vikas