Creating new column and using an if statement

[Samkim]

Hi 

I am new to Alteryx and am looking for a solution to my error below. I have created a new column  in my excel file and would like to use an if statement saying IF the field in column [Is Buffer Book] says "True", then output should be "1", "0"). 

Error: Parse Error at char(0): Invalid type in operator = =.

IF [Is Buffer Book] = "TRUE" THEN "1" ELSE "0" ENDIF

[estherb47]

Hi @Samkim 

Try changing the case in the IF to match what's in your data file.

Cheers!

Esther

[DataKyle · Accepted solution]

Is the field [Is Buffer Book] a string or a Boolean (bool) data type? 

If it is a boolean then Alteryx is already treating "TRUE" as 1 and "FALSE" as 0 in that field.

But if you're trying to make a new field you can use the formula to create a new field and use this:

if you want string output:

IF [Is Buffer Book] = 1 THEN '1' ELSE '0' ENDIF 

or if you want integers:

IF [Is Buffer Book] = 1 THEN 1 ELSE 0 ENDIF