Any ideas how to do this nicely in KDB? Consider the table X:([]a:1 2 3;b:`abc11`abc22`abc33;c:10 20 30) I now want a new table Y that has the "abc" stripped out of the symbols in the second co...

Is there a neat way of looking up the key of a dictionary by an atom value if that atom is inside a value list ? Assumption: The value lists of the dictionary have each unique elements Example: ...

I have a table in kdb with 3 columns: date, currency, fx rate. Some of the fx are missing, and I want to replace the null fx by the value on the previous day, for the same currency obviously. I can...

how can I access functions/variables in the root namespace once I jumped into another namespace. Example like this: q)\d .cfg q)domIV:1000 q)\d . q)n:1000 And then later on I know how to acces...

I am aware of this resource. But it does not spell out what parameters .u.upd takes and how to check if it worked. This statement executes without error, although it does not seem to do anything: ...

I want to ensure all values in column x are no smaller than 0.5, so I do: update x:max (x 0.5) from myTable But this gives an error (in Studio For KDB+): An error occurred during execution of t...

There's a new language Q, based on R, which was based on S ... you get the idea. Sadly, Q appears to be very slow in automining unicoins. Plus, Q : we don't have TIME for your little games! ...

I have two directories that each contain a date-partitioned splayed table. Each directory has its own sym file as expected. The tables are exactly the same. I want to consolidate this into one dir...

I'm writing a q script that loads a db in a particular path and does some processing on it. The location of the db is currently hardcoded in the script, but I want to pass the db path as an argumen...