Exclude Null Names on Matching

[aveeeeeee7en]

Hi Community

See the Attachment for my Requirement.

Regards

Aviral Nag

[sudeepkm]

you may try like below.

Load *, Applymap('AAA',name,'NULL') AS New11

Inline [

name,    code,    Dept

Ron,    11,        aa

,    11,        cc

John,    12,        ss

Rick,    13,        cc

] Where name<>'';

[mangalsk]

Hello,

Find the attachment