Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to load some data from a SQL server database but would like to filter out null values for a specific field. The standard 'is null' statement does not seem to work. Any ideas?
Cheers!
Erik
That does not seem to work. But after trying again I found that the 'is null' statement does work.
Load
*
where not Field1 is null
Hi
Try this statement in the script after From Clause
Where len("Category") <> 0;
In place of category write your field name.
Regards,
Nirav Bhimani
I also have to do this sort of test of lenght as I've not found a way to test the negative of a IsNull() function. Is tihs accepted practic ?
Jonathan
That does not seem to work. But after trying again I found that the 'is null' statement does work.
Load
*
where not Field1 is null