Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning
I'm having a problem with the loading of some data from SQL server, here the query:
LOAD
field1,
field2,
field3,
field4,
field5;
[Table Name]:
SELECT
field1,
field2,
field3,
field4,
field5
FROM Table WHERE field5 is not null;
If i visualize the table i can found all the field with field5 value NULL.
If from GUI i select "hide null value" the data disappear
Thank you
Hi Feda,
You can try like this as well, but you have to be careful while putting a 'where' condition since it might omit relevant information from other fields.
LOAD
field1,
field2,
field3,
field4,
field5;
[Table Name]:
SELECT
field1,
field2,
field3,
field4,
field5
FROM Table
WHERE len(trim(field5))>0;
If you run your select query against your database directly, not from QlikView, do you get records returned with NULL values in field5?
SELECT field1, field2, field3, field4, field5
FROM Table WHERE field5 is not null;