ETL and Data Integration tools - Modern ETL software for everyone

I'm mapping a source field that has either a "Y" or "N" value to a target field that has either a 0 or 1. I made the field Calculated and put the following in, but it doesn't seem to work I'm always getting 0.

Iif([F40]=="Y";1;0)

Can you please clarify what I'm doing wrong. Thanks.

Try

Iif('[F40]'=='Y',1,0)

Thanks, that worked. The example in the Calculation editor and on page 35 of the documentation shows semi-colons.

Is there a way to do any type of a "case" statement, for if you multiple conditions? Or do you just have to keep nexting the "Iif"?

Currently there is no case statement supported, use iif instead.
There was a spelling mistake in documentation which was corrected a week ago