Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?
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.
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,
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