Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fill down rows based on current row value within a group

steve87
7 - Meteor

Hello,

 

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

image.png

 

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

 

image.png

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

 

4 REPLIES 4
kat
12 - Quasar

Hi @steve87

 

Think this should do it:

Multi row.PNG 

 

Cheers

Kat

steve87
7 - Meteor

Thank you kat! This worked :)

SamDesk
11 - Bolide

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.

 

Capture.PNGCapture.PNG

 

Sam :)

steve87
7 - Meteor

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

 

image.png

Labels