Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to load 100mn row data from Postgrest SQL into QlikSense. It was loading properly, but suddenly it is loading only some lakh rows. I have not made any changes to the script. I also tried loading for a specific date by applying "where date=specific date", it showed right numbers. when I remove the date filter again it is loading only few rows. Can some one help, why is this happening?
Did you check the number if rows in the DB ??? If its loading properly for specify date than I don't think the problem is with the script .. Try to check your join and where conditions once that might me limiting the records
Thanks for your reply Avinash.
I am loading single table. Not doing any joins and also not applying any where conditions.
did u add any limit load in ur data?
i u hve limit load i think it will not allow to load i think.
Not limiting any data. I am just adding fields from ODBC connector and loading.
chk ur date field as same previous values. and can u paste ur some scrpt here....till where condition.
try to restrt ur application once and give a try
LOAD |
field1, |
Date, |
field3, |
field4, |
field5; |
SQL SELECT |
field1, |
Date, |
field3, |
field4, |
field5 |
FROM "DB"."public"."stemp_qlik" where Date='2016-04-03'; |
Hi, Santhosh,
As I understand correctly. Your script without "where Date='2016-04-03" load all the data correctly before, but only load part of the data now. Have you checked whether you have missing data in your database?
Zhihong
is the data available same on that day which u mentioned above with where condition?
if i load data for a specific date, it is loading.if i remove where condition, I am getting some strange data.