Multirow formula does not repond to "IF" statement

Hello all

I ma trying to use multirow formula to basically fill blanks with text from above. I recon I can do this with an IF statement however it shows me this.

Any idea why it wont work? Basically I am trying to select line description and add text into blanks in that column but it wont even let me to use an IF statement.

Thanks 🙂

Workflow

Transformation

Accepted answers

All comments

atcodedog05

Hi @jpolomsky

Formula prompt feature is not available in Mutli-row formula tool.

You need to go to function tab of Mutli-row formula tool to get formulas.

Here is a resource to help you out https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Hope this helps and answers your question 🙂

philipmannering

It's coming up with a red squiggly line because it's incomplete, but if you're trying to fill-down the empty rows try this,

IF isnull([Line Description]) 
then [row-1:Line Description]
else [Line Description
endif

Let me know if this works.

Thanks,

Philip

Emil_Kos

Hi @jpolomsky,

The multirow formula wasn't working as expected:

You need to go to functions option and choose conditional and double click If statement in order to populate it.

This is the formula that you want to paste:

IF c THEN t ELSE f ENDIF

Please keep in mind that it isn't formula tool and you will need to make more clicking here 🙂

Please mark my post as an answer if this was helpful!

marcusblackhill

Hey @jpolomsky !

Well, if I understand right, you need to do something like the formula below:

IF isempty([Line Description]) or isnull([Line Description])

THEN [Row-1:Line Description]

ELSE [Line Description]

ENDIF

Hope that help you!

jpolomsky

Thanks a lot! It worked.

I also wonder, for multirow formula, I can do that for one column at a time or can I do multiple columns all at once?Alike in formula function?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703