Accumulation in script help

[Anonymous]

how to get count of rows in load script

Date                ID

24/04/2017       11

25/04/2017       10

26/04/2017       12

27/04/2017       37

want to know count of rows if select 26/04/2017 - count should be  3, if 27/04/2017 --- count should be 4

[sunny_talwar]

You mean if 27/04/2017 is selected count should be 4.... may be use RowNo() to count

LOAD Date,

     ID

     RowNo() as Count

Resident ...

Order By Date Asc;

[Anonymous]

Let var = NoofRows('YourTable');

[Anonymous]

No Sunny its not working

[Anonymous]

could you explain again what you need...

[Anonymous]

I want an extra field in load script where  it should tell me the count of rows, if I select 26th Date it should show the count as 3 and if it is 27th count as 4

[sunny_talwar]

So what issue did you run into by using RowNo()?

[Anonymous]

Pls find attached app Sunny, whenever I select dates the count is shown as 1

[sunny_talwar]

Try Max(Count1) as your expression

[Anonymous]

Thnx Sunny, my bad, i haven't posted the my entire question correctly, I want 1 step back accumulation in the script as a new field