Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can i load data without null values
SRS
Maybe put WHERE IsNull(YourField)=0 in your load statement?
HI,
You can achieve this in this way.
Load * from ABC where not isnull(Field1);
Here Field1 is the field from which you dont want the null data.
Regards,
Kaushik Solanki
Hi,
Load * from Table_Name where Field_Name <> ' ' ;
Hope it helps
Regards
Ravikumar