KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home › Forums › kdb+ › Applying nested conditions in q › Re: Applying nested conditions in q

dwalshq

Member

September 23, 2021 at 12:00 am

Another option is to use vector conditional (?)

https://code.kx.com/q/ref/vector-conditional/

q)update new_col:?[a=`F;[?[b<c;`hi;`welcome]];[?[c>d;`hi;`welcome]]] from T 
a b c d new_col 
------------------ 
F 10 9 10 welcome 
R 20 21 22 welcome

Main Office Contacts

AMERICAS
Tel: +1 (212) 447 6700
EMEA
Tel: +44 (0)28 3025 2242
APAC
Tel: +65 65921960
ANZ
Tel: +61 (0)2 9236 5700

Useful Information

Software Support
Services
Careers

Resources

Resource Center
Customer Success
Events
News Room
Legal Center

KX® and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member

Please allow a few minutes for this process to complete.

Report

You have already reported this .