Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

app map?

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

Thank BKC

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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
Partner - Creator
Partner - Creator

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
Not applicable
Author

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
Not applicable
Author

Yes