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.
See the attached file. Cell referencing doesn't work exactly the same as in Excel, but it is absolutely doable. In this example, i filtered out the rows i wanted to replace data for and appended the specific points from another filter. A little hard to explain in text, but the example will be more helpful.
well there is a way to do it through just a couple tools (using Multi-Row Formula), but you'd have to know exactly how many rows up it would be from the first "future" row you encounter. The way i show above is a little more explicit and flexible in how you choose your row - it just happens to use multiple tools. Keep in mind the number of tools isn't always indicative of speed within Alteryx. If the number of tools are bothersome, you can either wrap in a macro or place the section of tools in a container and minimize. :)