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

You could use SWITCH() instead of if

SWITCH(Table[Column];
1;"Alpha"
2;"Beta"
3;etc.
etc;etc)
  • 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
      Anonymous wrote:

      thanks for reply, I get syntax error

      the ";" I use in the code might need to be a "," in your settings.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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