qlikview load data only newest date

[spikenaylor1]

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

[vamsee]

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)

[spikenaylor1]

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

[vamsee · Accepted solution]

Here you go