Formula troubleshooting

[gabrielmier222]

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

[binuacs]

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

[binuacs]

@gabrielmier222 Multi-Formula version

[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 

[binuacs · Accepted solution]

@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!