KX Community

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.