fgh

[#1]

Hello,

I have a small problem which I cant solve. I have had some very helpful answers on here but was trying to solve the problem in table graph formulas which I now dont think I can do. So the alternative is to import the data and deal with it on import. here is my problem

Original data
ref1	date	Amount
123456	01/05/2013	100
123456	02/05/2013	200
123456	03/05/2013	200
123456	04/05/2013	100
123456	05/05/2013	200
123456	06/05/2013	100
123456	07/05/2013	200
123456	08/05/2013	100
123456	09/05/2013	150
ABCDE	01/05/2013	100
ABCDE	02/05/2013	100
ABCDE	03/05/2013	100
ABCDE	04/05/2013	100
ABCDE	05/05/2013	100
ABCDE	06/05/2013	150
ABCDE	07/05/2013	100
ABCDE	08/05/2013	100
ABCDE	09/05/2013	100
What I want   it to look like in QV
ref1	date	Amount	Amount2
123456	01/05/2013	100	100
123456	02/05/2013	200	200
123456	03/05/2013	200	200
123456	04/05/2013	100	100
123456	05/05/2013	200	200
123456	06/05/2013	100	100
123456	07/05/2013	200	200
123456	08/05/2013	100	100
123456	09/05/2013	150
ABCDE	01/05/2013	100	100
ABCDE	02/05/2013	100	100
ABCDE	03/05/2013	100	100
ABCDE	04/05/2013	100	100
ABCDE	05/05/2013	100	100
ABCDE	06/05/2013	150	150
ABCDE	07/05/2013	100	100
ABCDE	08/05/2013	100	100
ABCDE	09/05/2013	100

You will see that for each ref I want to remove the value corresponding to the max date for that reference.

Does anyone know how I would achieve this.

Thanks in advance

[Nicole-Smith · Accepted solution]

See the load script in the attached:

[#3]

Thank a lot very helpful has solved my problems. Cheers

Alan