topic How to find next date value. in App Development

How to find next date value.

Anonymous — Tue, 10 May 2016 06:20:42 GMT

Hi,

Please help me by checking the attachments. I put i=0 to 20, but I need the last row to know dynamically for max value of i.

Note: Message was edited by Community Moderator for spelling and clarity

sunny_talwar — Tue, 10 May 2016 19:29:49 GMT

Try this may be:

Demo3:

LOAD RowNo() as Key,

[ClosingBalanceDate],

[ClosingBalance]

FROM [lib://Desktop/Demo3.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

FOR i=0 to FieldValueCount('Key')

test6:

Load DISTINCT

[ClosingBalanceDate],

[ClosingBalance]as OpeningBalance,

if(Peek([ClosingBalance],$(i))<>null(),peek([ClosingBalance],$(i+1)),0)as ClosingBalance

Resident Demo3;

NEXT i

DROP Table Demo3;

Anonymous — Wed, 11 May 2016 03:17:18 GMT

Hi Sunny,

Thanks for your response.But your code is not working for Closing Balance.

But I solved the issue.