Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have Day as column and month as row and
Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'inactive'}>}ACCOUNT_CODE)
as expression.
Now i want to include days where FinalFlag is null(I want to show as blank) in pivot table.
Any suggestions on this?
and u have null values for ur FinalFlag ? If so, why?
I'd suggest u to create a new value in ur script for this null() value; and then u can add it in all of ur expression .
maybe sthing like this:
Load *, if (len(trim(FinalFlag))=0,'null',FinalFlag) as newFlag;
load
....,
FinalFlag,
..
from ....;
How are u defining your FinalFlag field in the script?
if (isnull(fieldname)
Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE))
FinalFlag has active,inactive and new status. I want to show new and inactive together in pivot table
It shows all days but values are blank
and u have null values for ur FinalFlag ? If so, why?
I'd suggest u to create a new value in ur script for this null() value; and then u can add it in all of ur expression .
maybe sthing like this:
Load *, if (len(trim(FinalFlag))=0,'null',FinalFlag) as newFlag;
load
....,
FinalFlag,
..
from ....;