Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
its_anandrjs

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;

Not applicable
Author

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

its_anandrjs

Otherwise make all timestamp like

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

Not applicable
Author

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?

Not applicable
Author

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.

sudeepkm
Specialist III
Specialist III

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

its_anandrjs

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.

Not applicable
Author

no don't have any where clause.

suheshreddy
Contributor III
Contributor III

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