How can I make an IF statement to hold the values of different data types.

2 followers
0
Avatar

I have to use the formula IF(ISBLANK(X);"FALSE";X). it is not working because the data type of X and "false" is string and that of X is Boolean. How can I make it work.. I think it should not have been the constraint. when I use the same data type it works but not if the data type is different. Please let me know how can I make it work without changing the data type of the columns.

Ishfaq

1 comment

  • Avatar
    Alan Mark

    Ishfaq,

    Thank you for your question regarding the Datameer Function "IF".

    Please note that, per the documentation, it is a requirement for the IF function that the result arguments must be the same data type.

    That is to say, you must convert the arguments to be the same type before using the IF function.  

    You can use the Datameer Function "T" to convert any column to string type, which will allow you to use IF.  

    0
Please sign in to leave a comment.