How to apply case switch on boolean columns

Hello !

I would like to create a custom column base on boolean columns, but can’t figure out the correct syntax. What I would like to do would look something like this :

newColum = case([is_valid], "Valid", [is_waiting], "Waiting", "Invalid")
newColum = case([is_valid] = true, "Valid", [is_waiting] = true, "Waiting", "Invalid")

However both of these are not considered correct. Am I missing something obvious ?

Thank you for your help,

Hi @Augustin
There’s an issue open of it: - upvote by clicking :+1: on the first post
Some databases might understand [is_valid] = 1 so you can try that.

Thanks for your answer. Already tried it but it doesn’t seem to work on PostgreSQL.

@Augustin Sorry, linked to the wrong issue - here’s the correct one: - upvote by clicking :+1: on the first post