topic Re: How to get all records in straight table without missing? in QlikView

How to get all records in straight table without missing?

Tue, 06 May 2014 10:53:01 GMT

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.

Re: How to get all records in straight table without missing?

its_anandrjs — Tue, 06 May 2014 10:56:48 GMT

This records are timestamp formats if you not want time stamp try to change in the load script

Load

Date(DateEntered,'DD/MM/YYY') AS DateEntered

From Location;

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 11:16:38 GMT

Thanks. I tried it earlier itself. But it is not working. Any solution please?

Re: How to get all records in straight table without missing?

its_anandrjs — Tue, 06 May 2014 11:27:05 GMT

Otherwise make all timestamp like

Timestamp(DateEntered,'DD/MM/YYYY hh:mm:ss') AS DateEntered

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 11:36:01 GMT

Thanks. Actually I don't have any problem with timestamp or without timestamp. Because other records are populating. Only the above two are missing. How can I set this?

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 11:36:54 GMT

try adding rowno()

This creates a unique row for each data entry.

else try removing last part of the load statement from memory msq? this will force it to load all data and not ignore a line with same data as another line.

Re: How to get all records in straight table without missing?

sudeepkm — Tue, 06 May 2014 11:39:26 GMT

Do you have any data exclusion logic in your where clause and as a result these two records are getting ignored?

Re: How to get all records in straight table without missing?

its_anandrjs — Tue, 06 May 2014 11:49:43 GMT

May be due to some logic this date is not display for cross check that your model is fetch this record or not try to write a where condition in another separate application by taking backup of previous one.

write like

Load

Fields..

DateEntered

From Location

Where DateEntered = '28/04/2014 12:16:36' and DateEntered = '28/04/2014 13:43:18';

Try to populate only based on this two records and do this where this fro DateEntered field where is is available in the tables.

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 11:53:10 GMT

no don't have any where clause.

Re: How to get all records in straight table without missing?

suheshreddy — Tue, 06 May 2014 12:02:25 GMT

Load rowno() as anyfield in load statement and in straight table add anyfield and hide it

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 12:06:59 GMT

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

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 12:08:46 GMT

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

Tbl:

LOAD Name,

DateEntered,

DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

Re: How to get all records in straight table without missing?

sudeepkm — Tue, 06 May 2014 12:14:59 GMT

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.

Re: How to get all records in straight table without missing?

suheshreddy — Tue, 06 May 2014 12:21:08 GMT

Tbl:

LOAD

Rowno() as anyfield, Name,

DateEntered,

DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 12:44:35 GMT

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

Re: How to get all records in straight table without missing?

sudeepkm — Tue, 06 May 2014 12:46:21 GMT

can you paste your data load script here?

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 12:49:18 GMT

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?

Re: How to get all records in straight table without missing?

sudeepkm — Tue, 06 May 2014 12:57:50 GMT

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.

Re: How to get all records in straight table without missing?

its_anandrjs — Tue, 06 May 2014 13:03:35 GMT

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

Re: How to get all records in straight table without missing?

Tue, 06 May 2014 13:03:39 GMT

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.