Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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;
This is an example
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;