Select max record for each dimensione during script

[qvdrago]

Hi all,

I woult like load only the last 20 invoice for each customer

Load .....

Customer, InvoiceDate, InvoiceNumber, Value

from resident InvoiceArchive;

Thank you very much for your help

[maxgro]

try with

NEW:

LOAD * where ID <= 20;
NoConcatenate LOAD
*,
AutoNumber(InvoiceDate, Customer) as ID
Resident InvoiceArchive
order by Customer, InvoiceDate desc;

[qvdrago · Accepted solution]

Hi Max

Work perfectly