Cumulative calculation on the basis of fields

[ruma_barman]

Hi All,

Need your help!!

My input table is this:

Load * inline
[
Contract No , Installment Date
18702,18/02/2019
18702,18/03/2019
18702,18/04/2019
18703,19/02/2019
18703,19/03/2019
18704,18/02/2019
18704,18/03/2019
18704,18/04/2019
18704,18/05/2019

];

In this I am trying to add a column where on the basis of contract no and sorted Intallment Date ,I should have a series of Installment No starting from 1 like this 

Expected Output table is:

Contract No	Installment Date	Installment No
18702	18/02/2019	1
18702	18/03/2019	2
18702	18/04/2019	3
18703	19/02/2019	1
18703	19/03/2019	2
18704	18/02/2019	1
18704	18/03/2019	2
18704	18/04/2019	3
18704	18/05/2019	4

Thanks and Regards,

Ruma

[tresesco · Accepted solution]

Try like:

AutoNumber(RowNo(),[Contract No]) as [Installment No]

[ruma_barman]

Hi Tresesco,

Thank you for your instant response. It works but 

with this function  the qvd of actual data table takes 11 mins to load ,without this it takes few secs. Is there any alternate way?

Thanks and Regards,

Ruma

[tresesco]

That is probably because without this new field creation your qvd load is becoming an 'optimized load'. Alternative would be to create this field one step prior, i.e. while you are creating the qvd.