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 trouble to get the condition working and syntax working, any help appriciate 

cheers 

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.

     

7 Replies

  • 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

      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