Forum Discussion
If condition
Hi experts I have a column that retuens 1,2,3,4,5,6, etc I want to have a condition that if (table[column] = 1 than return alpha if (table[column] = 2 than return beta etc having a little trou...
Anonymous wrote:I have changed ; to , but i get below error
thanks for reply, I get an error , "Function'swtich' does not support comparing value of type text with values of type integer, consider using value or format function to convert one of the values,
how do I get around it ?
thanks
Anonymous wrote:
Anonymous wrote:thanks for reply, I get an error , "Function'swtich' does not support comparing value of type text with values of type integer, consider using value or format function to convert one of the values,
how do I get around it ?
You have to change your columns datatype to integer instead of text. Or you could use "1" instead as 1.
thanks for reply, I get syntax error
Anonymous wrote:thanks for reply, I get syntax error
the ";" I use in the code might need to be a "," in your settings.