Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I need to show Null values also in Filter Pane Object. I think Filter Pane object suppresses the Null Values. How to achieve this.
Thanks in Advance
Janardhan
Hi,
Try Like as below
Data:
LOAD *,
if( isnull(FIELD_NAME) or len(trim(FIELD_NAME))=0 ,1,0) as FlagNull
FROM SOURCE........................................................
Null:
noconcatenate
load *
resident Data
where FlagNull=1;
drop table Data;
Thanks to all ,
Hi,
Try NullCount()
Regards,
Jagan.
Please close the thread by marking the correct answer
Hi janardhan
Please mark as Correct Answer to close the thread.