# Linking vector columns

**URL:** <https://forum.kx.com/t/linking-vector-columns/13455>\
**Category:** Community Support\
**Tags:** imported, kdb-and-q\
**Created:** [June 30, 2022, 12:00am UTC](https://forum.kx.com/t/linking-vector-columns/13455 "2022-06-30T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mg4](https://avatars.discourse-cdn.com/v4/letter/m/dbc845/32.png) [@mg4](https://forum.kx.com/u/mg4)\
**Post date:** [June 30, 2022, 12:00am UTC](https://forum.kx.com/t/linking-vector-columns/13455/1 "2022-06-30T00:00:00Z")

</div>

[https://learninghub.kx.com/forums/topic/linking-vector-columns](https://learninghub.kx.com/forums/topic/linking-vector-columns)

Hi,

Is there a way to link vector columns so that when we do something like asc, the corresponding column will also re-arrage:

```
tbl:([] sVec:((`b`c`a);(`c`a`b);(`a`b`c));sNum:((2 3 1);(3 1 2);(1 2 3))); tbl 
sVec sNum 
----------- 
b c a 2 3 1 
c a b 3 1 2 
a b c 1 2 3 

update sVec:asc'[sVec] from tbl 
sVec sNum 
----------- 
a b c 2 3 1 
a b c 3 1 2 
a b c 1 2 3 

Desired output (Where each symbol is linked to number in same vector position): tbl1 
sVec sNum 
----------- 
a b c 1 2 3 
a b c 1 2 3 
a b c 1 2 3
```

&nbsp;

Many thanks!

---

<div class="post-metadata">

**Author:** ![rocuinneagain](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/rocuinneagain/32/287_2.png) [@rocuinneagain](https://forum.kx.com/u/rocuinneagain)\
**Post date:** [June 30, 2022, 12:00am UTC](https://forum.kx.com/t/linking-vector-columns/13455/2 "2022-06-30T00:00:00Z")

</div>

[iasc](https://code.kx.com/q/ref/asc/#iasc") gives you the sorted idexes which you can use

```
q)update sVec:sVec(@)'iasc each sNum,asc each sNum from tbl 
sVec sNum 
----------- 
a b c 1 2 3 
a b c 1 2 3 
a b c 1 2 3
```

&nbsp;