Load script cumulative problem

Anonymous — Wed, 31 Jan 2018 14:47:13 GMT

Hi ,

Im struggling with a cumulative load script issue I cant figure out 😕

What I want to archieve, is to get a cumulative sum from "Transaktio_capital_called" and "Transaktio_capital_distributed" columns. The load script should calculate the cumulative sum by company. "Transaktio_payment_date" defines the date.

How can this be archieved?

LOAD "Transaktio_payment_date" as pvm,

"Transaktio_Year",

"Transaktio_month",

"Transaktio_investor" as Investor,

"Transaktio_investee"&'.'&"Transaktio_investor" as Company.investor,

"Fund_investor",

"Transaktio_investee" as Company,

"Transaktio_fund_direct",

"Transaktio_capital_called",

"Transaktio_capital_distributed";

SQL SELECT "Transaktio_payment_date",

"Transaktio_Year",

"Fund_investor",

"Transaktio_month",

"Transaktio_investor",

"Transaktio_investee",

"Transaktio_fund_direct",

"Transaktio_additional _information",

"Transaktio_capital_called",

"Transaktio_distributed",

"Transaktio_capital_distributed",

"Transaktio_profit",

"Transaktio_divident",

"Transaktio_interest",

"Transaktio_valuation",

"Transaktio_other_income",

"Transaktio_operation",

"Transaktio_type",

"Transaktio_Shares",

"Transaktio_Program",

"Transaktio_Instrument",

"Transaktio_Instutype"

FROM "DW".dbo."Kaikki.transaktio"

Re: Load script cumulative problem

kaushiknsolanki — Wed, 31 Jan 2018 15:04:40 GMT

Hi,

Check this links.

Cumulative sum in script

How can I calculate a cumulative sum in load script?

Regards,

Kaushik Solanki

Re: Load script cumulative problem

Anonymous — Fri, 02 Feb 2018 08:13:23 GMT

Thanks, Ill try to figure it out from there

topic Load script cumulative problem in App Development

Load script cumulative problem

Re: Load script cumulative problem

Re: Load script cumulative problem