community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Fill down rows based on current row value within a group

Highlighted
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

 

Quasar

Hi @steve87

 

Think this should do it:

Multi row.PNG 

 

Cheers

Kat

Meteor

Thank you kat! This worked :)

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 :)

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