Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
trying to load data set
a record for a sample for a batch has been entered on 16 March 2020 with data
it was found that the data was wrong
another record was entered for same batch with the corrected data but on the 17 March 2020
both records now show in the source table.
How do I load the data but only ensuring the newest record for that entry is loaded.
I.e. I only want the record for the 17 March 2002 to load, not the 16 March 2020
obviously this applies for looking at all records where there may have been corrected info entered in the source tabel
field I am looking at is ResultEnteredOn
Many thanks for Looking
Couldn't help notice but the timestamps on your tests are the same.
Assuming this is just because of sample data, as the result is the same that of input. (I/p 6 rows, O/p 6 rows)
I still cant get the solution provided to work, it still displays all the records.
per your question.
TestReportedName - for Test1
on the source DB, there are 5 entries for Test1, all are subtests calculated at the same time when the data is entered. The ResultName shows in my example test 1a and 1b, the resultNumericEntry values are different, but The TestReportedName and ResultSampleNumber and ResultEnteredOn values will be the same for the 2 rows in my example, in reality the 5 rows will be the same, except for the resultNumericentry.
Could I ask if you could provide a QVW file showing that the load script works, so I can try to understand why it doesn't on my load.
Many thanks for all the help.
Regards
Spikenaylor
Here you go