Clean way to do conditional statement in SQL?

Community Support
1

I was wondering what the best way to do conditional update in q? I know i can do the below but wondering if theres a shorter/cleaner way.

 

 

 

t:flip ab!(1 2;01b) update c:{$[x;true;false]} each b from t

 

 

 

2

update c:?[b;true;false] from t

3

exactly what i was looking for! thank you

4

Hi @ekallivrousis, try using a vector conditional - https://code.kx.com/q/ref/vector-conditional/

update c:?[b;true;false] from t

b = vector of booleans being passed in