Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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, ''
];