topic Re: Is it possible to calculate a cumulative in a loading script ? in App Development

Is it possible to calculate a cumulative in a loading script ?

JuMo — Wed, 21 May 2025 13:18:57 GMT

I am importing the following data

Test1:
LOAD * INLINE [
Test1.Year, Test1.Month, p_type, Amount
2021, 01, a, 10
2021, 01, b, 8
2021, 02, a, 3
2021, 02, a, 5
2021, 02, b, 10
2021, 03, a, 9
2021, 03, a, 10
2021, 03, b, 7
2021, 03, b, 6
];

Is it possible, during the loading script to add a calculated column that represent the the cumulated value but only for one p_type ?

What I want to obtain is the following table :

Year	Month	p_type	Amount	Cumul Amount
2021	1	a	10	10
2021	1	b	8	8
2021	2	a	3	13
2021	2	a	5	18
2021	2	b	10	18
2021	3	a	9	27
2021	3	a	10	37
2021	3	b	7	25
2021	3	b	6	31

Re: Is it possible to calculate a cumulative in a loading script ?

Mark_Little — Wed, 21 May 2025 12:42:19 GMT

You will be able to achieve this by applying an order on load and using the Peek function.

Mark

Re: Is it possible to calculate a cumulative in a loading script ?

JuMo — Wed, 21 May 2025 13:19:51 GMT

Thanks for your hint,

I have the following (satisfactory) solution:

Test1:

LOAD * INLINE [

Test1.Year, Test1.Month, p_type, Amount

2021, 01, a, 10

2021, 01, b, 8

2021, 02, a, 3

2021, 02, a, 5

2021, 02, b, 10

2021, 03, a, 9

2021, 03, a, 10

2021, 03, b, 7

2021, 03, b, 6

];

Test2:

Load

Test1.Year as Test2.Year,

Test1.Month as Test2.Test1Month,

p_type as Test2.p_type,

Amount as Test2.Amount,

Amount+Peek('AmountYTD',-1,'Test2') As AmountYTD

Resident Test1;