Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get all records in straight table without missing?


Hi,

I have a straight table with data. The columns are

Name, DateEntered, DaysinQueue.

All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.

Could anyone suggest me how to get this records?

Thanks.

33 Replies
Not applicable
Author

Thanks. I tried. These two dates are not populating. How can I change this to get the records?

Not applicable
Author

Where I can add this as I have this table in load

Tbl:

LOAD Name,

     DateEntered,

     DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

sudeepkm
Specialist III
Specialist III

Almost everyone has suggested a reason or a cause of the record not being visible even after that you do not see it then it would be great if you can share your QVW and can let us know which exact record (record ID) you have in the database and not being pulled to the QVW.

suheshreddy
Contributor III
Contributor III

Tbl:

LOAD

Rowno() as anyfield, Name,

DateEntered,

DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

Not applicable
Author

Thanks. The problem is the database there are 4463 records. The qvd loading only 4365 records. How can I get complete set of reords in to qvd?please help

sudeepkm
Specialist III
Specialist III

can you paste your data load script here?

Not applicable
Author

Tbl:
LOAD Rowno() as Rowno,
    ID,
    Name,
    DateEntered
SQL SELECT *
FROM tblCustomer;

STORE Tbl INTO C:\Extractor\Tbl.qvd;


DROP TABLE Tbl;

EDIT: It is showing a message as ODBC read failed after loading 3016 records. Will this be the problem?

sudeepkm
Specialist III
Specialist III

could be. if you have database interface tool like sql+ or sql developer then try to run the same script in there and check if you are getting the same error or not.

you may also check the detail error message.

its_anandrjs

Check your access database may be problem is there after 3016 records.

Not applicable
Author

unfortunately I don't have any other environment to run this. It is not showing any detailed error message it is showing only QVX_Unexpected_End_of_data. as in attached. How can I set this please help me.