# Add a Linked Column with an enumeration other than sym

**URL:** <https://forum.kx.com/t/add-a-linked-column-with-an-enumeration-other-than-sym/11222>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [August 31, 2016, 9:54pm UTC](https://forum.kx.com/t/add-a-linked-column-with-an-enumeration-other-than-sym/11222 "2016-08-31T21:54:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hoffmanroni1](https://avatars.discourse-cdn.com/v4/letter/h/8dc957/32.png) [@hoffmanroni1](https://forum.kx.com/u/hoffmanroni1)\
**Post date:** [August 31, 2016, 9:54pm UTC](https://forum.kx.com/t/add-a-linked-column-with-an-enumeration-other-than-sym/11222/1 "2016-08-31T21:54:00Z")

</div>

Example, I have tables

companyInfo:( exchange:`NYSE`NDQ`NYSE`TSE;sector:4?(“Banking”;“Retail”;“Food Producers”);MarketCap:30000000+4?1000000)

trades:(sym:`a`b`c`a`b;ex:`NYSE`NDQ`LSE`NYSE`NDQ;price:5?100.);

How do enumerate the exchange column of companyInfo to a separate file then the sym enumeration?

Then I need to add the link column to the partition and update .d, correct?

Thanks!

---

<div class="post-metadata">

**Author:** ![Flying1](https://avatars.discourse-cdn.com/v4/letter/f/f4b2a3/32.png) [@Flying1](https://forum.kx.com/u/Flying1)\
**Post date:** [September 1, 2016, 7:06am UTC](https://forum.kx.com/t/add-a-linked-column-with-an-enumeration-other-than-sym/11222/2 "2016-09-01T07:06:00Z")

</div>

q)companyInfo:( exchange:`NYSE`NDQ`NYSE`TSE;sector:4?(“Banking”;“Retail”;“Food Producers”);MarketCap:30000000+4?1000000)

q)trades:(sym:`a`b`c`a`b;ex:`NYSE`NDQ`LSE`NYSE`NDQ;price:5?100.);

q)`:companyInfo/ set update`:sym\_ex?exchange from companyInfo

`:companyInfo/

q)`:trades/ set update`:sym?sym,`:sym\_ex?ex from trades

`:trades/

q)\dir

" Volume in drive E has no label."

" Volume Serial Number is XXXX-XXXX"

“”

" Directory of e:\DEV\db"

“”

“2016.09.01 14:02 \<DIR\> .”

“2016.09.01 14:02 \<DIR\> ..”

“2016.09.01 14:04 \<DIR\> companyInfo”

“2016.09.01 14:02 14 sym”

“2016.09.01 14:04 25 sym\_ex”

“2016.09.01 &nbsp;14:04 &nbsp; &nbsp;\<DIR\> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;trades”

" 2 File(s) 60 bytes"

" 4 Dir(s) 68,000,000,000 bytes free"

q)\l .

q)meta companyInfo

c | t f a

---------| -----

exchange | s

sector | C

MarketCap| j

q)meta trades

c | t f a

-----| -----

sym | s

ex | s

price| f

q)type each flip companyInfo

exchange | 21

sector | 87

MarketCap| 7

q)type each flip trades

sym | 20

ex | 21

price| 9