Test

[Anonymous]

Test

[sunny_talwar]

So you need the 6 rows from the 8 rows of just the two highlighted rows?

[maxgro]

maybe this (it depends on the condition you want to choose the record, I used the load order desc)

A:

LOAD *, rowno() as Id INLINE [

Year, Month, Quarter, AId, Acc, DId, Dsc, Sales, PSales, Date, Maintenance Period, Maintenance Sales, Provider, Table

2015, May, Q2, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 05/02/2015, 05/02/2015, 3250, Psys, Maintenance

2015, Jun, Q2, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 06/02/2015, 06/02/2015, 3250, Psys, Maintenance

2015, Jul, Q3, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 07/02/2015, 07/02/2015, 3250, Psys, Maintenance

2015, Aug, Q3, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 08/02/2015, 08/02/2015, 3250, Psys, Maintenance

2015, Jul, Q3, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 07/02/2015, 07/02/2015, 250, Psys, Maintenance

2015, Aug, Q3, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 08/02/2015, 08/02/2015, 250, Psys, Maintenance

2015, Sep, Q3, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 09/02/2015, 09/02/2015, 0, Psys, Maintenance

2015, Oct, Q4, {0AA84B07}, NOOC, {DBB22D92}, ESys, 0, , 10/02/2015, 10/02/2015, 0, Psys, Maintenance

];

B:

NoConcatenate

load * Resident A

where Year&Month <> Peek('Year') & Peek('Month')

order by Year, Month,Id desc;

DROP Table A;