Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Apllymap function not working well

Hi All,

In Applymap function can I use more than two parameter values,

Please find below statement,

ApplyMap:
Mapping load * Inline
[
Grade,Score
A,1
B,2
C,3
D,4
]
;

UsingApplyMap:
LOAD * Inline
[
Emp_Name,Salary,Loc
A,1000,Chennai
B,2000,Bangalore
C,1000,Bangalore
D,1000,Bangalore
E,2000,Bangalore    /* Not available in ApplyMap table
]
;

load ApplyMap('ApplyMap',Emp_Name,'unassign') as Emp_Grade Resident UsingApplyMap;

Above statement working fine,

But i am looking like,

load ApplyMap('ApplyMap',Emp_Name,’assign,'unassign') as Emp_Grade Resident UsingApplyMap;


Output like,

assign

assign

assign

unassign

Thanks & Regards,

Senthil…

1 Solution

Accepted Solutions
MVP
MVP

Re: Apllymap function not working well

Maybe just use a map that has a constant second field value: 'assign',

ApplyMap:
Mapping load Grade, 'assign' as FieldB Inline
[
Grade
A
B
C
D
]
;

2 Replies
MVP
MVP

Re: Apllymap function not working well

Maybe just use a map that has a constant second field value: 'assign',

ApplyMap:
Mapping load Grade, 'assign' as FieldB Inline
[
Grade
A
B
C
D
]
;

Not applicable

Re: Apllymap function not working well

Hi Swuehl,

Thanks a lot...

Regards,

Senthil..