If condition

[Anonymous]

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 

[Anonymous]

You could use SWITCH() instead of if

SWITCH(Table[Column];
1;"Alpha"
2;"Beta"
3;etc.
etc;etc)

[Anonymous]

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]

thanks for reply, I get syntax error

[Anonymous]

---

@Anonymous wrote:

thanks for reply, I get syntax error

---

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

[Anonymous]

---

@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 · Accepted solution]

---

@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]

Perfect thanks 

used "1"