count of rows as field on daily basis

[#1]

Hi ,

How to get no. of rows added on daily basis as field and rangesum count while loading

Ex: source                                                      

A    B     C       Date                                           

14  10    20    4/12/2017

16  25    30    5/12/2017

19  40    50    5/12/2017

20  60    50    6/12/2017

Expected Result

A    B     C       Date           count     RangesumCount                            

14  10    20    4/12/2017          1                1

16  25    30    5/12/2017          2               1+2

19  40    50    5/12/2017          2

20  60    50    6/12/2017          1               1+2+1

thnx

[Anil_Babu_Samineni]

Or

Count(TOTAL <Date> Date)

[#3]

Hi Anil,

I want this to be achieved in Load script

[sunny_talwar]

May be this

Aggr(RangeSum(Above(Count(Date), 0, RowNo())), Date)

[#5]

This would work fine on UI but not in load script Sunny