Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
pls see attach
I have not deleted the rows that do not have to (flag=0)