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!
解決済! 解決策の投稿を見る。
Can you please elaborate on what you put instead of ' [Row-1:NewField]'
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
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
Still not working:
Is this for the current version of Alteryx? I'm not fully following the instructions... Thanks!