Fill down rows based on current row value within a group

Hello,

I have a workflow and data set is currently looking like this

I would like to have column prt_7d_used_count for each prt_7d_used_flag=1 summing the previous rows within the same parent_part. Final data set should look like this

Other solution would be to to fill down 0 with 1 where wrong_flag=1 within the same parent_part

looping through 2 input files2nd version.yxmd

Workflow

Datasets

Output

Tips and Tricks

Date Time

Dynamic Processing

Accepted answers

kat

Hi @steve87

Think this should do it:

Multi row.PNG

Cheers

Kat

looping through 2 input files2nd version.yxmd

All comments

kat

Hi @steve87

Think this should do it:

Multi row.PNG

Cheers

Kat

looping through 2 input files2nd version.yxmd

steve87

Thank you kat! This worked

SamDesk

Hello @steve87,

Another solution I've found to produce your desired outcome is to split the data in a filter using:

prt_7d_used_flag = 1

...before making the running count and then simpling unioning the data back together again.

Sam

looping through 2 input files2nd version.yxmd

steve87

Thank you @SamDesk but solution @kat provided starts counting from 1 where flag is set to 1 which is exactly what i was looking for

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703