Formula troubleshooting

Hi y'all,

using the Muti-Field Formula tool, I am trying to populate the first cell in my Description column, by using the following IF statement:

if [LINE_NO]==1 then "Data Conversion 12/31" else "" ENDif

My output is still returning with a blank description column. any thoughts?

Thanks in advance

-Gabriel

Output

Accepted answers

binu_acs

@gabrielmier222 Make sure the Line_No field data type is numeric if it is string type then update your formula like below

IF [LINE_NO] = '1' then "Data Conversion 12/31" else "" ENDif

All comments

binu_acs

@gabrielmier222 Why don't you use the formula tool instead of the multi-formula tool?

binu_acs

@gabrielmier222 Multi-Formula version

Multi_Formula_080523.yxmd

gabrielmier222

Thanks for replying so quickly!

I tried the formula tool, but Alteryx doesnt like something about it that seemed to be resolved by using the Multi-formula

This is my error for the multi tool

apathetichell

First off - for multi-field formula - you must check at least ONE field in the top part of the config. Second - this is toggled to numeric. You need to select at least one string field here if you are supplying a string in the return - like you are here.

Third... why are you using a multi-field versus a standard formula here?

gabrielmier222

Using multi-field because standard formula tool gives me this error

binu_acs

@gabrielmier222 Make sure the Line_No field data type is numeric if it is string type then update your formula like below

IF [LINE_NO] = '1' then "Data Conversion 12/31" else "" ENDif

gabrielmier222

Thanks, you're brilliant!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703