KX Community

hzadonis369

Hi, Masters: Last week, I created a partition table to store fundmental data, for example, Sector A has 10 equities and Sector B has 8 equities. The data changed day by day and was loaded by a csv file which exported from Stock Exchange system. It wo...

hzadonis369

Hi, Masters: I have a litter bit complex qSql, for example: select CntCOMP:count IND, avg Grade, COMP by IND, OptDate from (`IND xasc select RIC, COMP:link.COMPANY, BuySell, OptDate, OptPrice, Grade, Comment, IND:link.IND, LOC:link.LOC from AShare_Po...

hzadonis369

Hi, Masters: I have a table with sym field, for example: q)show t:([]sym:(1+5?5)?\:5?`3)sym----------------,`ceo`edc`edc`edc`apa`mlf`ceo`ijl`apa`apa`mlf,`mlf How to add each sym and make it be a list, such as: `ceo`edc`edc`edc`apa`mlf`ceo`ijl`apa`apa...

hzadonis369

Hi, Masters: Say I have a list contains dynamic sym variables: `a`b`a`b`c`d`c`b`a... How can I count each sym and get an output such as: `a:4 `b:3 `c:2 `d:1

hzadonis369

Hi, gyorokpeter-kx: Thanks! you're right. It's stupid that add a ";" at the end of "dbpath". It's works fine now!

hzadonis369

Thanks. Yes, I just mentioned 2 methods(scan and over).

hzadonis369

scan: (,\)t[`sym] over: (,/)t[`sym] thinking in Q.

hzadonis369

q)lt: `a`b`a`b`c`d`c`b`a q)group lta| 0 2 8b| 1 3 7c| 4 6d| ,5 q)count each group lta| 3b| 3c| 2d| 1 Seems not difficult. Any other method?

KX Community

User Statistics

User Activity

How the sym file reads data from partition table?

Functional a multi-condition query

How to add all sym into one list?

Count items from a dynamic list

Re: How the sym file reads data from partition table?

Re: How to add all sym into one list?

Re: How to add all sym into one list?

Re: Count items from a dynamic list