James1
New Contributor
since ‎2009.07.28
Tuesday

User Statistics

  • 57 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi Masters,I have a table T like this:date, close------------------I would like to get this one:date, close, yield1, yield2, yield3, ... ,yield20---------------------------------------------------------------------As you see, I need to get 1-20 days ...
Hello everyone,My MacBook was updated to macOS Catalina automatically.I can not start q as it will be an error like this: Bad CPU type in executableCould you please help me to figure out and fix this?Thank you.James
Hi, 1. Define table tt:([]id:1 1 1 2 2 2;c1:`a`a`b`a`a`b;c2:`x1`x2`x3`y1`y2`y3)id c1 c2-----------------1 a x11 a x21 b x32 a y12 a y22 b y3 2. Pivot table t by this function:pivot:{P:asc exec distinct c1 from t;:exec P#(c1!c2) by id:id from t}pivot[...
Hi,Table t:c1 c2 c3-----------`a 1 `x`b 2 `y`c 3 `zHow to convert rows to a list like this:L:((`a;1;`x);(`b;2;`y);(`c;3;`z))Thanks.
Hi, All My kdb+ server is using logging mode. However, after an insert error occurred, kdb+ server encountered a rollback. I checked the reference: http://code.kx.com/wiki/Cookbook/Logging#Errors_and_rollbacksErrors and rollbacksAn error after a part...