

megan_mcp
Forum Replies Created
-
megan_mcp
AdministratorJune 6, 2025 at 9:05 am in reply to: Unable to locate the kx academy sandboxHi @sicp
Here is a link to the kdb+/q Developer 1 Course that Michaela talks about in the video –kdb+/q Developer: Level 1 – KX Learning Hub
I will make sure to add links to the courses in the Products Overview course to eliminate confusion.Thanks!
-
megan_mcp
AdministratorJune 4, 2025 at 10:50 am in reply to: Error while loading trips table – KX Introductory session Workshop 1Hi @Sarah
Can you save your progress so that I can access your server to have a closer look please?
Thanks!
-
megan_mcp
AdministratorJune 3, 2025 at 3:05 pm in reply to: kdb+/q Developer Lv2 – list indexing : exercise GList just before 4.2 for typeHi @Ken__
1. The h at the end of the list isn’t related to the last value. The h is placed at the end of the list to indicate this is a list of data type values.
2. Do you mean why are the results showing the types before displaying the list even though the “show” query comes before the “type” query?
-
megan_mcp
AdministratorJune 2, 2025 at 3:43 pm in reply to: Issue resetting KX sandbox to undo file deletionCan you tell me what table it is please?
-
Hi @Kaitlin
Is it okay if I access your server to have a closer look? Make sure to save your progress!
Thanks 🙂
-
Hey @Alain
I’ve renamed your old instance “adv_capstone1” and your new instance is named just “adv_capstone”. I hope this helps!
-
-
megan_mcp
AdministratorJune 6, 2025 at 9:01 am in reply to: Options Trading Desk Capstone Project – exercise4.1 Fail edge15 Table FormatApologies for the delay in response I was out of office yesterday. I’m glad you have resolved the issue!
Any other questions, please feel free to ask 🙂
-
megan_mcp
AdministratorJune 4, 2025 at 11:09 am in reply to: Error while loading trips table – KX Introductory session Workshop 1 -
megan_mcp
AdministratorJune 4, 2025 at 10:46 am in reply to: kdb+/q Developer Lv2 – list indexing : exercise GList just before 4.2 for typeHi @Ken__
1. When running the type function, it will return the type code (an integer) indicating the data type of the value. The h represents that it is returning a short type code.
Whether we run it individually on each item e.g.
type `a type 1 type "b" Output: -11h //short type code for symbol -7h //short type code for int -10h //short type code for char
Or in one go over a list:
type each GList Output: -11 -7 -10h //short type codes for symbol, int, char
The “h” at the end indicates that it is displaying the short type code for those items.
2. I believe the output format is due to Jupyter’s output model. Commands such as show x prints the result of evaluating x, but does not return a value. Jupyter cells only display the value of the last expression, and show returns nothing (:: or null), the output is printed directly as a side effect, not as a result.
For example, running show L will output the query last but outputting L as a variable will run before the second query (screenshots provided below)
I hope this helps!
-
megan_mcp
AdministratorJune 3, 2025 at 7:17 pm in reply to: Issue resetting KX sandbox to undo file deletionI’ve sent you a private message about this 🙂
-
megan_mcp
AdministratorJune 3, 2025 at 2:08 pm in reply to: Issue resetting KX sandbox to undo file deletionAre you still experiencing this issue? If so, can I access your server to take a closer look?
Thanks!
-
megan_mcp
AdministratorJune 2, 2025 at 4:01 pm in reply to: Issue resetting KX sandbox to undo file deletionI would recommend running:
delete nbbo from `.
This will remove the table from memory and to reload the table run your code from exercise 1.1 again.
Let me know if you have any questions about this!
-
We are currently in the process of uploading our certifications to Open Badge and will let you know when this process is complete 🙂
Thanks!