I wanted to know if Alteryx has a solution to copy information from one row to the next based on conditions. For example sample 1 shows the original data with null rows. The goal would be to copy data from the rows above and the end result would be sample 2. I thought the multi row tool would work in this situation but it doesn't. Can this be accomplished?
Solved! Go to Solution.
Hey @anom23,
Here is one way to do this:
If you use the Transpose Tool you can get your table data into one column then use a multirow formula on all the data at once.
This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
@patrick_digan built a custom macro that allows you to combine the functionality of Multi-Row and Multi-Field formulas so that you can use your current approach, but write an expression to pull down values for multiple fields at once:
Find attached the way of doing this.
Let me know if there is any issue and do not hesitate to mark this answer as solution if it worked.
Thank you all!! All of these solutions worked. Thanks again.