topic Re: Missing records when load data from DB in QlikView

Missing records when load data from DB

alex_stone — Tue, 04 Jul 2017 23:30:04 GMT

Very strange, will missing some records when I load data from database.

e.g.

Sales_Performance:

load

；

SQL select * from Sales_Performance;

Will missing some records after execute the above script. We try the both ODBC and OLEDB connection. But, get the same result on QV application.

Re: Missing records when load data from DB

Anil_Babu_Samineni — Wed, 05 Jul 2017 04:03:36 GMT

This information is not sufficient to trouble shoot. Provide more information like how is your DB table looks like? and how many fields you are getting from DB to QLIK ?

Re: Missing records when load data from DB

BalaBhaskar_Qlik — Wed, 05 Jul 2017 06:44:46 GMT

Data load script is executed without error, but data is not loaded

Some common causes of error.

Debug the data load script to identify the issues.

A statement is not terminated with a semicolon, You have forgotten to terminate a statement with a semicolon.

Terminate all statements with a semicolon.

Single quote character inside a string, A string contains a single quote character in, for example, a SET variable statement.

If a string contains a single quote character, it needs to be escaped with an extra single quote.

Using single quote characters in a string

If you need to include single quote characters in a string, you can use an extra single quote as an escape character.

Example: The string '10 O''clock News' will be interpreted as 10 O'clock News.

Re: Missing records when load data from DB

PrashantSangle — Wed, 05 Jul 2017 06:57:55 GMT

it cant be happen.

Can tell us how you identify that it is missing some records??

Are you using any filter while fetching data either in sql or qlikview.

Regards,

Re: Missing records when load data from DB

alex_stone — Sun, 15 Oct 2017 11:17:09 GMT

Hi Sangle,

As what I understanding, QV will missthe duplicate record when load data.

Solution: We add one column as RecNo() to avoid this problem