Generic Load Help

[arusanah]

Hi Qlikers ,

I am trying to pivot Column using Generic Load. I am generating columns from "App Name" Field  and trying to fill values as yes or no , in case user doesn't have access to app. it seems to work however I'm having issue replacing Null with 'No'.  Tried many options but doesn't seems to work. where ever it is  null() I would like to see 'N'

Generic
Load Distinct
ID,
"App Name" ,
if(isnull( if ("App Name"='NULL' OR "App Name"=' ',NULL(),"App Name")),'No','Yes') as AccessFlag

RESIDENT [Win Access]
where Match("APP_NUM",150,400)
;

Any help will be appreciated.

Thanks

[Dalton_Ruer]

TER:
Load Territory, Country,
IF(Len(Country) = 0 or IsNull(Country), 'Null', 'Not Null') as Flag Inline [
Territory, Country
EU, DE
EU, FR
ASIA,
USA, US
AF, ''
];