mwoods
Forum Replies Created
-
Hi Akash, are you in the rendered version of the markdown file? You will not be able to edit code snippets there, you can edit in the unrendered version (saving file your edits will appear in the rendered version) or else just work directly in the scratchpad.
It is a good idea to add your code to project.md and continue to keep a backup up periodically by saving, or if working in scratchpad by copy & pasting somewhere periodically.
-
To return 5 6 you will need to index at depth by passing a semicolon
mm[0;2] 5 6
Indexing by passing a list of integers returns all indexes so in this case:
mm 0 // returns the element at position 0 1 2 3 4 5 6
mm 2 // returns the element at position 2 - which doesn't exist
mm 0 2 // get both elements at positions 0 and 2 - because none at 2 we just get the 0 elements back 1 2 3 4 5 6
This concept covered in the free academy course in the module on List Amendment and eliding at depth.
https://learninghub.kx.com/courses/kdb-developer-level-2/lessons/lists/topic/list-indexing-access/
-
https://learninghub.kx.com/forums/topic/kx-academy-upgrade/
Hi
With the recent upgrade to our Academy sandbox, JupyterQ/embedpy have been removed since PyKX can now be configured as a replacement.
As a result, when running notebooks, you might notice that a q kernel is unavailable.
To resolve this, we recommend running a ‘git pull’ on the project or reopening the sandbox link from the course page. This should fix the issue automatically.I would recommend signing up to our kx.com/slack community to get up to date with future changes.
learninghub.kx.com
KX Academy Upgrade !! - KX Learning Hub
February 3, 2025 - KX Academy Upgrade !! - Hi everyone,
-
Try
optRef: update "D"$expiry from optRef;
-
Thanks for the clarification Alex, @kdb_newbie you can try the below:
ej[`col1;t1;t2] uj select from t1 where not col1 in t2.col1 col1 col2 col3 col4 col5 ------------------------ a 1 11 4 44 a 1 11 5 55 b 2 22 6 66 c 3 33 7 77 d 8 88
-
You can use xkey to key the col1 column with lj to get your desired result:
t1 lj `col1 xkey t2
My joins cheatsheet might help you:https://www.linkedin.com/posts/michaela-woods-50502b60_kdb-dataanalytics-joinoperations-activity-7126225089632563200-jUOz?utm_source=share&utm_medium=member_desktop
As well as the joins modules in the free Academy courses: https://learninghub.kx.com/courses/kdb-developer-level-1/lessons/joins/
linkedin.com
Michaela Woods on LinkedIn: #kdb #dataanalytics #joinoperations #cheatsheet
Joining tables in kdb+/q is straightforward, but selecting the correct type of join can be tricky, especially for newcomers. 🧐 I've put together a quick…
-
That’s correct, there are no video lectures for the developer level 3 course
-
-
Hi Juanse, part indicates something is off with your directory structure. I logged into your environment as admin and using ls could check there was indeed an erroneous file “5457”. I removed this file and was able to load the database.
This should work for you now, trade should be available to query
Thanks,
Michaela
-
@Juanse I have rerun the setup script again for you, see below steps, navigate to directory on Termnial, run setup.sh and then relaunch Developer from Launcher window.
I am not sure of the cause of the error, perhaps something you are running is triggering it but this fix should unblock you at least.
-
Hi @Juanse I reran your setups step (from the README) , can you try now?
-
Hi, our team have taken a look at your instance and two of your pipelines have database writers pointing to a database that nolonger exists.
Could you please share pipeline name and please check that the database writers are configured correctly?
-
This should now be resolved – sorry for the inconvenience!
-
Thanks for raising this. I have flagged with our development team and we will aim to resolve ASAP. I will let you know when its fixed. Apologies for this.
-
Did you get sorted Jonathan? If you want to DM your code for this function I can take a look
