how to select the last 3 recent orders (Order Date desc) by customer

[shamad]

Hi,

how to select the last 3 recent orders (Order Date desc) by Customer. (create QVD)

The result must be

A                           100                       20150220

A                           50                         20150110

A                           20                         20150103

B                           80                         20150215

B                           70                         20150208

B                           30                         20150105

From Table

Customer            N° Order              Date Order

A                           50                         20150110

B                           30                         20150105

A                           20                         20150103

B                           25                         20150104

A                           10                         20141225

A                           100                       20150220

B                           80                         20150215

B                           70                         20150208

…                           …                           …           

Thanks,

[alexandros17]

This is an example

[MK_QSL · Accepted solution]

Test:

Load

  Customer,

  Order,

  Date(Date#([Date Order],'YYYYMMDD')) as [Date Order]

Inline

[

  Customer, Order, Date Order

  A, 50, 20150110

  B, 30,     20150105

  A,          20,     20150103

  B,          25,     20150104

  A,          10,     20141225

  A,          100,    20150220

  B,          80,     20150215

  B,          70,     20150208

];

NoConcatenate

Temp:

Load

  Customer, Order, [Date Order], AutoNumber(Customer & [Date Order], Customer) as Number

Resident Test

Order By Customer, [Date Order] desc;

Drop Table Test;

NoConcatenate

Load * Resident Temp Where Number <=3;

Drop Table Temp;