topic Re: app map? in QlikView

app map?

Anonymous — Wed, 08 Apr 2015 07:15:07 GMT

when i go for applymap

t1:

mapping load

f1,

from

sales.xlsx

t2:

load

applymap('t1',f3,'un') as newmap

from bud.xlsx

her emy question is if i given f3 in applymap statment which is not matching in t1 table

generally first f3 will go for comparision with f1 or f2 or both f1 and f2

it means it check the matching data with only f1 or f2 also? or it ignore f2 field?

Anonymous — Wed, 08 Apr 2015 07:19:56 GMT

It will only check with f1 and if f1 and f3 is mapping it will give f2 value as newmap else un

Thank BKC

jsanchezh — Wed, 08 Apr 2015 07:21:45 GMT

When you use a map,

if your content in f3 matches your content in f1 then it returns the value in f2. But if doesn´t match f3 in f1, then it returns 'un' (in your case)

Greetings!

Anonymous — Wed, 08 Apr 2015 07:23:23 GMT

it means it is always go for comparision with first field right ?

mapping table syntax like

t1:

mapping load

id,

value

from sales.xlsx

Anonymous — Wed, 08 Apr 2015 07:24:08 GMT

Yes