topic Load script : pb to create table with cumulated amount in App Development

Load script : pb to create table with cumulated amount

sdavinblanc — Thu, 22 Jan 2026 08:46:09 GMT

Hello,

I'm facing a problem to create a table with cumulated amount from two tables.

I have a table BUSINESS_PERIOD with two colums :

- Business_code (Key)

- Period (year month format : yyyymm).

In this table you can find all period from the start of the business to the end.

I have a second table BUSINESS_ORDER with three columns :

- Business_code (Key)

- Period (year month format : yyyymm).

- Amount

In this table you can find only period where there is an amount associated.

I need to create a final table with three columns :

- Business_code (Key)

- Period (year month format : yyyymm).

- Amount

In this final table all period of each business need to be present and the amount is cumulated each month with previous months for each business.

You can find a screenshot of the tables with data in order to understand better.

I can't find how to do it...

I someone has an idea to help ! thank you

Re: Load script : pb to create table with cumulated amount

marcus_sommer — Thu, 22 Jan 2026 09:40:29 GMT

Try:

t1: load * from BUSINESS_PERIOD; left join(t1) load * from BUSINESS_ORDER;

t2: load *,
if(Business_code = previous(Business_code),
peek('KumAmount') + Amount, Amount) as KumAmount
resident t1 order by Business_code, Period;

drop tables t1;

Re: Load script : pb to create table with cumulated amount

sdavinblanc — Thu, 22 Jan 2026 10:30:43 GMT

It's not working...I have no amount in the KumAmount

Re: Load script : pb to create table with cumulated amount

marcus_sommer — Thu, 22 Jan 2026 10:37:07 GMT

Are all records with the periods + codes + amounts there - means the join as first step is working?

Re: Load script : pb to create table with cumulated amount

sdavinblanc — Thu, 22 Jan 2026 10:39:27 GMT

Yes the join is working before using the previous and peek syntax.

Re: Load script : pb to create table with cumulated amount

marcus_sommer — Thu, 22 Jan 2026 10:46:13 GMT

Add a small adjustment to treat NULL as ZERO:

t2: load *,
if(Business_code = previous(Business_code),
rangesum(peek('KumAmount'), coalesce(Amount, 0)),
coalesce(Amount, 0)) as KumAmount
resident t1 order by Business_code, Period;

Re: Load script : pb to create table with cumulated amount

sdavinblanc — Thu, 22 Jan 2026 11:09:17 GMT

It's working fine, thank you !