Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please look at the file i attached where i wan to eliminate nulls in date fields
try like this
if(len(trim(date))>0,Date) as Date
if you want to eliminate the data where date is null then have a where condition like
LOAD *
from table
where len(trim(date))>0;
Hi You can try With multiple way .. depend on your data like
if(IsNull(Date),'Null',Date) as Date OR
if(len(trim(date))>0,Date) as Date
Hi,
Load *
from table
where len(trim(Date))<>0;