Test

Anonymous — Mon, 17 Oct 2016 13:18:29 GMT

Test

Re: How to fetch the data according to latest occurrence in script.

sunny_talwar — Mon, 17 Oct 2016 16:40:47 GMT

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

maxgro — Mon, 17 Oct 2016 16:53:01 GMT

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

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

];

NoConcatenate

load * Resident A

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

order by Year, Month,Id desc;

DROP Table A;