Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Thanks. I tried it earlier itself. But it is not working. Any solution please?
Otherwise make all timestamp like
Timestamp(DateEntered,'DD/MM/YYYY hh:mm:ss') AS DateEntered
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?
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.
Do you have any data exclusion logic in your where clause and as a result these two records are getting ignored?
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.
no don't have any where clause.
Load rowno() as anyfield in load statement and in straight table add anyfield and hide it