Copy Data from the Row above based on Criteria.

[anom23]

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?

[IraWatt · Accepted 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 

[DataNath]

@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:

https://community.alteryx.com/t5/Public-Community-Gallery/Multi-Row-Field-Column-Macro-example/ta-p/...

[Emmanuel_G]

@anom23 

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.

[binuacs]

@anom23 One way of doing this

[anom23]

Thank you all!! All of these solutions worked.  Thanks again.