Apply Map Help

[aveeeeeee7en]

Hi Community

I need some changes. Please see the Attached qvw.

Regards

Aviral Nag

[chiru_thota]

See attached QVW. Just.Just I used set analysis.

I don't see any issue with your apply map.

[aveeeeeee7en]

Thanks for your reply.

But I need the logic from Back-end.

[#4]

Hi ,

try this

AAA:

Mapping Load * Inline [
code, New
11 , BBB
12, SSS
];

AAA:
Load * Inline [
name, code, Dept
Ron , 11, aa
, 11, cc
John, 12, ss
, 13, cc
];

Res:
Load *,
name&code&Dept as Key,
Applymap('AAA',code,'NULL') AS New11
Resident AAA
Where name&code&Dept<>'11cc';

Drop Table AAA;

Drop Field Key;