Get value from max date of the month

[nicholas5141]

Hi All,

Need assists on load script get value based on last day of every month.

Input:

Load * Inline [

Date, Value

02/01/2017, 2

05/01/2017, 3

04/02/2017, 44

08/02/2017, 33

10/03/2017, 22

15/03/2017, 53

20/04/2017, 5123

21/05/2017, 53

];

Expected output

Month               Value

Jan 2017           3

Feb 2017          33

March 2017       53

April 2017          5123

May 2017           53

Thanks.

[maxgro · Accepted solution]

Input:

Load * Inline [

Date, Value

02/01/2017, 2

05/01/2017, 3

04/02/2017, 44

08/02/2017, 33

10/03/2017, 22

15/03/2017, 53

20/04/2017, 5123

21/05/2017, 53

];

Output:

NoConcatenate load

*

Resident Input

Where MonthStart(Date) <> Monthstart(Peek('Date'))

order by Date desc;

DROP Table Input;

[florentina_doga]

pls see attach

I have not deleted the rows that do not have to (flag=0)