Replacing a null value with a different row's value

Question

Hello all,

I am working in alteryx and trying to prevent data loss that occur due to null values. One idea I have is that a null value may appear in a row but is actually something that a different row has the correct value for. I have tried to display this dilemma with the image below:

I have typed some script on the side that to me sounds like it would work but I am not sure how to operationalize it into alteryx. Could anyone help me out? Additionally, does this sort of problem have a name that I could use to do further research on?

Thanks so much for your time and effort:)

Ben M

binu_acs · Answer

@benjaminmartin16 One way of doing this with the Multi-Row tool

Multi-Row_1005.yxmd

Garabujo7 · Answer

Hello @benjaminmartin16 ,

You can do that with the Multi-row formula.

The greatest thing about this tool is that you can work with rows above or below and that will allow you to do what you are looking for.

Gabriel

Christina_H · Answer

Check out the multi-row formula tool, that will do what you need.