Multi-row formula issue with numeric field

Hello,

Can anyone please help me fix the issue of the attached workflow? I'm trying to have the workflow to fill in "number" column with the pre-defined numbers. For example, row 1 on number column shows P50. I want this to be filled down until P005 and the same process continues. Thanks so much for your help!

New folder.zip

Transformation

Accepted answers

echuong1

You were in the right direction with the multi-row formula!

For the configuration, you actually want to update an existing field rather than creating a new field (top section).

For the expression, essentially, we want to check if the number field is empty. If it is, take the value from the row above it. Alteryx will process records from top to bottom, so you can think of it like filling values going downward.

Let me know if this helps! Workflow attached. You will have to update the input tool.

New Workflow1.yxmd

echuong1

Your original configuration was set to create a new field. It needs to be set to update an existing field, Number.

All comments

echuong1

You were in the right direction with the multi-row formula!

For the configuration, you actually want to update an existing field rather than creating a new field (top section).

Let me know if this helps! Workflow attached. You will have to update the input tool.

New Workflow1.yxmd

LordNeilLord

Hey @Wynn

Try If IsEmpty([number]) Then [Row-1:number] Else [number] Endif

And set the MR Formula to Update Number column (or new column set to VWSting)

Wynn

Hi Neil,

Still the same issue. I also wonder why my original formula was wrong. I just wanted to understand the underlying issues as I feel like our formulas are pretty much the same

Wynn

Hi Chuong,

Thanks so much for your help! This works.I completely understand your reasoning of why you are using the empty field formula. However, if we were to use the number formula, is there a way to tweak the formulas so that they work? I just try to understand what's wrong with my formulas.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703