This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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!
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.