I have two columns with True and False - Bool data type. Column A is my input data which is Bool and Column B is the data I created. I'm trying to create a check function for these two columns which is
IF [QCC Treatment For Straddle Purposes] = [QCC Treatment for Straddle Purposes - Alteryx]
THEN " "
ELSE "Error"
ENDIF
For column B(the data I'm creating) - I cant have the "=" in the formula as Bool doesn't accept this operator.
IF [Option is deep In the Money - Alteryx] = "False" && [Qualified Exchange] = "True" && [Is Grant Date > 30 Days from Expiration] = "True" && [Not Granted by Options Dealer] = "True"
THEN "True"
ELSE "False"
ENDIF
I cant change this to String as my input data from file is changing "True/False" into "T/F" and I'm unable to match Column A = Column B. Is there any other alternative way for "=" in Bool?
Solved! Go to Solution.
Try this:
IF NOT [Option is deep In the Money - Alteryx] && [Qualified Exchange] && [Is Grant Date > 30 Days from Expiration] && [Not Granted by Options Dealer]
THEN "True"
ELSE "False"
ENDIF
You don't need the "=" sign, just need to use your fields as the clauses.
Cheers,
Awesome @Thableaus. Thanks for the help.