If in Apply Map?

[qlikuser222]

hi Everyone,

i have a requirement where we have to use if in apply map condition's.

Please find attached where i described the code. Please help me with understanding the logic.

Thanks

[sasiparupudi1]

Dont really get the logic behind your requirement but may be like this?

Test:

load * Inline [

ID, Stage, Desc

AAA, 9, Propose

AAA, 10, Flight

AAA, XXX, Implement

BBB, 9, Propose

BBB, 10, Flight];

Map_Stage:

Mapping Load

Stage,

Stage

Resident

Test;

Drop Table Test;

Test1:

Load

ID,

Stage_1,

Date,

Applymap('Map_Stage',Stage_1,If(Date<201731,9,10)) As Stage

inline [

ID,Stage_1, Date

AAA, XXX, 201731

BBB, YYY, 201731,

BBB, QQQ, 201810];

[sasiparupudi1]

Did you manage to get this working?