kdb+ and q
Q+A on all things kdb+ database and the q language
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

How to set a timer and let q run automatically

Hello,I am trying to have two functions run automatically. For example, for function 1, I want it to run once a day; for function 2, I want it to run every 10 minutes.Can anyone guide me how to set up a timer and make it run as scheduled? Many thanks...

kc3031 by New Contributor
  • 554 Views
  • 1 replies
  • 0 kudos

Functional select with fby, grouping on multiple columns

Hi KDB Gurus,I have the functional form of this query:select from rows where 1=(count;i) fby ([]sym;market;id;price;size;eventType)as:?[rows;enlist(=;1;(fby;(enlist;#:;`i);(+:;(!;enlist`sym`market`id`price`size`eventType;(enlist;`sym;`market;`id;`pri...

How to set timer and let q run automatically

Hello,I am trying to run a script that contains two function.For function 1, I only need to run once a day; for function 2, I hope I can run every 10 minutes.Can anyone guide me how to set up a timer and make it?Many thanks in advance!Best,Kelly

kc3031 by New Contributor
  • 844 Views
  • 2 replies
  • 0 kudos

Functional select with fby, grouping on multiple columns

Hi KDB gurus,I've figured out that the functional form of this query: select from rows where 1=(count;i) fby ([]sym;market;id;price;size;eventType)is this:?[rows;enlist(=;1;(fby;(enlist;#:;`i);(+:;(!;enlist`sym`market`id`price`size`eventType;(enlist;...

Get table data form a website.

Hi Gurus, Is there any way I could come to a website like this: https://www.instituteforsupplymanagement.org/ismreport/mfgrob.cfm?SSO=1 and pull data the "MANUFACTURING AT A GLANCE" table or the whole table from that website? I guess I somehow need t...

VA by New Contributor
  • 574 Views
  • 1 replies
  • 0 kudos