If the cell in the flag column is Null, then in the comments column, Alteryx is to add rem

[snadeau456]

If the cell in the flag column is Null, then in the comments column, Alteryx is to add this comment "remove from 12219", else leave it blank.

Tried many different SQLs but its not working.

If (Null([FLAG_CD])
Then([Comments] "remove from 12219")
Else ""
ENDIF

[usmanbashir]

@snadeau456- Look at the screenshot below. Use snippet below in Formula tool.

IF IsNull([FLAG_CD]) THEN 'remove from 12219'
ELSE ""
ENDIF