Load From SQL Server Fail

[Anonymous]

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

[Umesh]

Hi
Qlikview have an Option in presentation layer to "Hide Null Value " based in the Field added in Dimension , since load table in the script is combination of subset for 5 fields in 1 table
You can check the CTRL + T ( table viewer) .

LOAD id, first_name, last_name, email, gender, City, [Purchase Date], [Car Model]
FROM [..\Downloads\MOCK_DATA.csv] (txt, utf8, embedded labels, delimiter is ',', msq)
WHERE(not IsNull([Purchase Date]));

[jyothish8807]

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;

[Colin-Albert]

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;