Formula not working as V_String or Double

I am trying to create a new column to return an "N" if there is a 0 in the column and a "Y" if there is any other value.

I am trying to write an IF statement to do this, however, I keep coming up against the error message "An operator must be between operands". This is the formula I was trying:

IF ([RegEx1]= "0" THEN "N" ELSEIF ([RegEx1] THEN "Y" ENDIF

IF ([RegEx2]= "0" THEN "N" ELSEIF ([RegEx2] THEN "Y" ENDIF

I am struggling to understand how to resolve this. I was looking around the community and have tried changing the data type between V_String and Double but neither way is working.

I have attached some sample data which shows the data in the columns and the desired outcome. Any help would be much appreciated

Indicator Sample Data.xlsx

Help

Accepted answers

rkapoor

I've attached the unpackaged version. Here is the code for both columns also:

IF [RegEx1] = 0 THEN "N" ELSE "Y" ENDIF

IF [RegEx2] = 0 THEN "N" ELSE "Y" ENDIF

workflow_adamhill3.yxmd

All comments

rkapoor

Hi there

You need to use a simple IF ELSE Block I think. Have a look at the attached workflow.

I have created 2 columns as RK Output1 and RK Output2

workflow_adamhill3.yxzp

adamhill3

@rkapoor wrote:
Hi there
You need to use a simple IF ELSE Block I think. Have a look at the attached workflow.
I have created 2 columns as RK Output1 and RK Output2

Thank you, but I cannot open a packaged workbook as I am in an older version of Alteryx and unable to update.

Could you by any chance attach a non-packaged version or just paste the code?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703