Discussion board where members can get started with QlikView.
when i go for applymap
applymap('t1',f3,'un') as newmap
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?
Go to Solution.
It will only check with f1 and if f1 and f3 is mapping it will give f2 value as newmap else un
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)
it means it is always go for comparision with first field right ?
mapping table syntax like