topic Re: Load From SQL Server Fail in QlikView

Load From SQL Server Fail

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Load From SQL Server Fail

Umesh — Tue, 20 Nov 2018 12:19:44 GMT

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]));

Re: Load From SQL Server Fail

jyothish8807 — Wed, 21 Nov 2018 05:48:52 GMT

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;

Re: Load From SQL Server Fail

Colin-Albert — Wed, 21 Nov 2018 18:00:04 GMT

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;