app map?

[Anonymous]

when i go for applymap

t1:

mapping load

f1,

f2

from

sales.xlsx

t2:

load

f3

f4

f5

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 · Accepted solution]

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]

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]

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]

Yes