Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    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.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks for reply, I get syntax error

Anonymous's avatar
Anonymous
Not applicable
7 years ago
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Perfect thanks 

      used "1"