Sum of current and previous rows in load script

[jmialoundama]

Hi, 

I have this script and the output table:

Donnees_Inline:
LOAD * INLINE [
sortie_stock_pn_ic,sortie_stock_pn_article,sortie_stock_date,sortie_stock_quantite,sortie_stock_reference,sortie_stock_type_mouvement
008Q614,61037916AA,30/09/2022,1,,VP
008Q614,61037916AA,02/02/2023,1,,VP
008Q614,61037916AA,28/02/2023,,3,Peremption
008Q614,61037916AA,30/05/2023,1,,VP
008Q614,61037916AA,02/10/2023,1,,VP
008Q614,61037916AA,31/12/2023,,2,Peremption
008Q614,61037916AA,30/01/2024,1,,VP
008Q614,61037916AA,31/05/2024,,5,Peremption
008Q614,61037916AA,02/06/2024,1,,VP
008Q614,61037916AA,30/09/2024,1,,VP
008Q614,61037916AA,31/12/2024,,1,Peremption
1234,1234BB,05/10/2022,1,,VP
1234,1234BB,05/05/2023,1,,VP
1234,1234BB,06/07/2023,,5,Peremption
1234,1234BB,01/10/2024,1,,VP
1234,1234BB,11/11/2024,,1,Peremption
1234,1234BB,03/12/2024,1,,VP
1234,1234BB,12/12/2024,,3,Peremption
];

NoConcatenate
Donnees:
LOAD 
	sortie_stock_pn_ic & sortie_stock_pn_article as key_ic_article
	, sortie_stock_pn_ic
	,sortie_stock_pn_article
	,date(sortie_stock_date) as sortie_stock_date
	,sortie_stock_quantite
	,sortie_stock_reference
	//,sortie_stock_type_mouvement
Resident Donnees_Inline
ORDER BY sortie_stock_date,sortie_stock_pn_ic,sortie_stock_pn_article;

DROP TABLE Donnees_Inline;


NoConcatenate
Peremptions:
LOAD distinct
    key_ic_article,
    sortie_stock_pn_ic,
    sortie_stock_pn_article,
    sortie_stock_date,
    //sortie_stock_quantite,
    sortie_stock_reference,
    If(Previous(sortie_stock_pn_ic)=sortie_stock_pn_ic AND sortie_stock_reference <>'' ,RANGESUM(sortie_stock_reference,Peek('sortie_stock_reference'))) As Stock_reference_sum
    //sortie_stock_type_mouvement
RESIDENT Donnees
//where sortie_stock_reference <>''
ORDER BY sortie_stock_date,sortie_stock_pn_ic,sortie_stock_pn_article;
    

I want this in final : 

In my load script i have add this line, but the result is not good : 

If(Previous(sortie_stock_pn_ic)=sortie_stock_pn_ic,RangeSum(sortie_stock_reference,Peek('Stock_reference_sum')),sortie_stock_reference) As Stock_reference_cum

Thanks in advance for your help

[Aurelien_Martinez · Accepted solution]

Hi,

NoConcatenate
Peremptions:
LOAD
    key_ic_article,
    sortie_stock_pn_ic,
    sortie_stock_pn_article,
    sortie_stock_date,
    sortie_stock_quantite,
    sortie_stock_reference,
    If(Peek(sortie_stock_pn_ic)=sortie_stock_pn_ic,Peek(Stock_reference_sum) + Alt(sortie_stock_reference, 0), Alt(sortie_stock_reference, 0)) As Stock_reference_sum
    //sortie_stock_type_mouvement
RESIDENT Donnees
//where sortie_stock_reference <>''
ORDER BY sortie_stock_pn_ic, sortie_stock_pn_article, sortie_stock_date;

DROP Table Donnees;

Peremptions2:
NoConcatenate
LOAD
  key_ic_article,
  sortie_stock_pn_ic,
  sortie_stock_pn_article,
  sortie_stock_date,
  sortie_stock_quantite,
  sortie_stock_reference, 
  if(Len(trim(sortie_stock_reference))>0, Stock_reference_sum, Null()) as Stock_reference_sum
resident Peremptions;

DROP Table Peremptions;