Copy Data from the Row above based on Criteria.

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?

Sample Input1.xlsx

Sample Input2.xlsx

Workflow

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

IraWatt

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.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

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/879896

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.

Copy Data from the Row above based on Criteria.yxmd

binu_acs

@anom23 One way of doing this

Multi-Row_0926.yxmd

anom23

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

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335