Add a Linked Column with an enumeration other than sym

Community Support
1

Example, I have tables

companyInfo:( exchange:NYSENDQNYSETSE;sector:4?(“Banking”;“Retail”;“Food Producers”);MarketCap:30000000+4?1000000)

trades:(sym:abcab;ex:NYSENDQLSENYSENDQ;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!

2

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

q)trades:(sym:abcab;ex:NYSENDQLSENYSENDQ;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  14:04    <DIR>          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