Hey All, How do you use KDB sin/cos/tan to solve for the angles of a triangle? Im not asking about SOHCAHTOA -- when I use the sin/cos/tan functions in KDB/q I get different results compared to other language's functions. Is there a conversion im mis...
I have a basic question: a['name] vs b[val;'name] Do I understand the first is a dictionary and I get the value that corresponds to a key "name"? But what data structure is the second? Is that a list? I am reading the code and trying to make sense of...
fileName:hsym `$"C:/users/data.csv" show t:("SSDD";enlist",") 0: fileName After running these two lines iam getting below error: OS reports no such file or directory. But data.csv is there in the above location.
Whats the largest decimal value KDB can handle. Im looking to deal with numbers that have over 17 decimal places
Hi guys, When i'm doing `$("1";"0") it is automatically showing as "10". Is there any way i can make it as `1`0
I need help to find out if there is compatible function in c++ class used to connect to db that would convert the large(24) decimal place to datatype compatible to kdb
Hi all, Anyone know if there's any way to control which directory is used during system commands? We have run into issues where /tmp is full and would like to use a different directory to avoid processes crashing.
Suppose we have table tblAAPL, tblIBM already, can I insert data into each table by using peach to accelerate the process? If tables do not affect each other. for example: insert[; data] peach `tblAAPL`tblIBM I tested, got noupdate error.
Hi Community, I have a dictionary of tables, so I want to convert them into functional queries but when I try to build it, it retrieves a type issue, Do you know if it is possible? Attached pic! Thanks, Richard
I want to add a column to an existing table based on nested conditions T:([]a:`F`R;b:10 20;c:9 21;d:10 22) Func:{[tab] If a=`F If bd new=`hi Else new='welcome } Please help.
I have a function which takes 2 arguments. Ill write some pseudo code for an idea f:{[x;y] $[x~`1;y;`0]} Then i have a table: t:([]a:`1`2`3;b:`4`5`6) Now i want to call that function and pass a and b to it from an update statement update c:f[a;b] fro...
Hi Community, I am trying to create a REST API that would have 2 method(get and post), and It would be initially an empty table tab:([] a:`$(); b:"i"$()) that would be filled out eventually. So I would be using .Q.hg(get) and .Q.hp(post) for it, my e...
Hi, everyone. I have some questions about wavg function. 0 wavg 5 / 5 5 wavg 5 / 5 2 wavg 2 3 7 / 4 5 2 3 wavg 3 / 3 According to the doc, the x and y of wavg[x;y] must both be numeric lists. But for these invalid inputs, wavg still yields some resul...
Can you please help me understand the below and why that number is converting to 99999 at end q)\P 0q)79347181.7179347181.709999993 q)\P 16q)79347181.7179347181.70999999 q)\P 15q)79347181.7179347181.71
Hello, I need to connect POWER BI with KDB. i tried using simba ODBC but iam having problem with theconnection when i try to connect to a kdb server which has partition table it shows error while connecting. Is there any other way to connect kdb with...
Good morning everybody! How to display a string without the quotes? Example: q) show "string" "string" q) show "string" string
Hi Community, We came across one issue in development. Say we've got an in-memory table "tbl", and want to insert "data" into this table regularly, not by appending, but inserting into specific row with "index". Currently we tried to do the following...
Hey all, In any modern browser, you can define your own search engine under settings. One useful case here is to setup a shortcut to code.kx, so that you can type a keyword (e.g. "kx") in your browser address bar, press tab and enter a search term su...
Greetings all, Trying to get add a numpy array (as a column) to a table table in pyq. Any help greatly appreciated.
Good Morning!I just got to know kdb + and the q language.I am reading and practicing based on the website https://code.kx.com/q4m3/.I just made several examples with lists.Now I'm in the dictionaries.Example:d1: `a`b`c! (1 2; 3 4 5; 6 7 8 9)Doubt:How...
Hi guy, I'm new to kdb and I just started to learn it. In my town (montreal) there are some hedge funds who are looking for kdb developer but all of them they are looking for +2 years of experience. I want to know, how did you land your first entry l...
