Fill in the Blanks with closest data

jenv20032000x

Greetings Alteryx Users, I'm hoping you can help me.

I have been using the multi row formula tool with no success. If the very first record is populated, I can use the -1row, but this is not always the case. Data can be spread out further than 1 row and it can be forwards rather than backwards. I've attached a simplistic view of my data but it illustrates my dilemma. Maybe I'm using the wrong tool. I eagerly await your input.

FillInTheBlanks.yxmd

Preparation

Accepted answers

binay2448

Find attached updated solution as requested

FillInTheBlanks_bk.yxmd

All comments

MarqueeCrew

@jenv20032000x ,

I think that I've solved the problem. I find first value (not null) and use it when prior row is null.

Cheers,

Mark

Ps the older version version will open with any AYX designer

FillInTheBlanks (MarqueeCReW).yxmd

FillInTheBlanks (MarqueeCReW) older version AYX.yxmd

atcodedog05

Hi @jenv20032000x

You would need to do bottom-up and up to bottom fill up like below.

Workflow:

Hope this helps : )

FillInTheBlanks.yxmd

binay2448

Hope this will resolve your issue..

FillInTheBlanks_bk.yxmd

jenv20032000x

Thank you for your reply binay2448. While your solution gets me closer to the desired result, it is off when the product or customer changes. In the desired output at row 9 is 1.5 and that carries forward through rows 10-12. This is because the customer and product is the same.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703