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

Alteryx designer Discussions

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

How to fill down values from x number of rows above

Atom

Hello!  I'm new to Alteryx.  Does anyone have a clever way of effectively filling down data from x number of rows above?  Similar to the way where you can double-click in excel and have the data fill in from above.  I was trying to use a multi-row function, but can't really figure out how to since the row of the data that needs to be copied varies.  I have the followding data set.  Thank you!
rtaImage (6).png
 

Atom
I answered my own question i think.  I am using the expression:

IF IsNull([Field_1]) THEN [Row-1:NewField] ELSE [Field_1] ENDIF
Exactly, the multi-row formula is the key for this. I'm not aware of any better method.

@SculptingData 
Atom

Can you please elaborate on what you put instead of ' [Row-1:NewField]'

Meteoroid

The "Row-1" means to look at the row preceding the active row, and ":NewField" is the name of another field (*or even the same field) from which to take the field value and then write it to [Field_1] if [Field_1] is null. 

 

It works perfectly! I wanted to thank the OP as your question and answer were very helpful!

 

Thanks!!

 

-C

Meteor

This is an awesome solution but I can't quite get it to work. It's not reading Row-1 as a formula for me and can't read that portion of it at all. Am I inputting something incorrectly? I'm trying to adjust the same field with the value from the rows above.

 

Thanks!

Jordan

 

IF IsNull([Success Month]) THEN

[[Row-1]:[Success Month]]

ELSE [Success Month] ENDIF

 

@acah @VizED @sammyjld @danielkresina 

Highlighted
Alteryx Certified Partner

@jark1294 

 

Take off the square brackets from [Row-1] and it should work.

 

Cheers,

Meteor

Still not working:

 

Capture.JPG

Alteryx Certified Partner

@jark1294 

 

You need to use Multi-Row Formula Tool

 

Cheers,

Meteor

@Thableaus 

 

Is this for the current version of Alteryx? I'm not fully following the instructions... Thanks!

Labels