Running Sum Aggregation

Hi All,

I have a day-on-day data and which has grouped by "CC","BA","Account" to calculate running sum and below is the outcome of running sum.

But the expectation is, if i select 03-04-2017 cumulative amount should be available i.e. all the values of 01-04-2017 and 03-04-2017.

I have records more then 10L, which is the best way to achieve the required output.

Attaching the input and required data workflow.

Running_Sum.yxzp

Workflow

Transformation

Preparation

Accepted answers

RolandSchubert

Hi @GayatriPanigrahi ,

you can remove this limitation by changing an option within the AppendFields tool:

Select "Allow all Appends" and it should work.

All comments

RolandSchubert

Hi @GayatriPanigrahi ,

I think, you have to create a list of all possible combinations of Date, CC, BA and Account (list of dates and list of combinations BA, CC, Account). You have to join the existing records to this list, including "unmatched" (i.e. date, that do not exist for a specific combination).

I've modified your workflow a bit. Let me know if it works for you.

Best,

Roland

Running_Sum.yxzp

GayatriPanigrahi

Hi @RolandSchubert

Thank you for the quick response.

The permutation and combination of data is huge and in given solution append filed has limitation to create combination upto 16 records only.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703