Sort a Table

[rocuinneagain]

For normal sorting operations see:

• https://code.kx.com/q/ref/asc/
• https://code.kx.com/q/ref/desc/

q)tab:([] sym:`a`b`c`d`e; x:5?10) q)tab sym x ----- a 8 b 1 c 9 d 5 e 4 q)`sym xdesc tab sym x ----- e 4 d 5 c 9 b 1 a 8

For your request perhaps rotate is what you are looking for

• https://code.kx.com/q/ref/rotate/

q)2 rotate tab sym x ----- c 9 d 5 e 4 a 8 b 1

 

 

[rolf]

q)t:([]sym:`a`b`c`d`e;x:til 5)
q)t iasc`c`d?t`sym
sym x
-----
c 2
d 3
a 0
b 1
e 4

if you want to move the desired records to the top but want to preserve the order of the rest of the table