[megan_mcp]

Hi @karce

The meta for your table seems correct. However, the first few rows of edgeProfileFull should look as follows (screenshot below).

I would suggest taking a look back over your edgeProfile table in 5.2 and your join statement in 5.3 to see if you can replicate the output in the screenshot.

Many thanks,

Megan

[megan_mcp]

Hi @jervischionh,

For exercise 1.3 can you make sure that if you are selecting a column from a table that you use backticks (Tables in kdb+ | Language | kdb+ and q documentation – kdb+ and q documentation (kx.com). E.g. When selecting time and endTime from the window table, instead of this:

window: (t[time];t[endTime]);

We would write it as this:

window: t `time`endTime;

This goes for the rest of the columns in your code.

For exercise 2.3 can you create a dictionary mapping the mysensor options as seen in the table below.

If you have any questions, please feel free to reach out.

Many thanks,

Megan

[megan_mcp]

Hi @jervischionh,

For exercise 1.3 can you make sure that if you are selecting a column from a table that you use backticks (Tables in kdb+ | Language | kdb+ and q documentation – kdb+ and q documentation (kx.com). E.g. When selecting time and endTime from the window table, instead of this:

window: (t[time];t[endTime]);

We would write it as this:

window: t `time`endTime;

This goes for the rest of the columns in your code.

For exercise 2.3 can you create a dictionary mapping the mysensor options as seen in the table below.

If you have any questions, please feel free to reach out.

Many thanks,

Megan

[megan_mcp]

Hi @Saidharsan

Can you send me your exact code for exercise 2.2 please?

For exercise 2.4 can you make sure to create a dictionary mapping the mysensor inputs, as seen in the table below.

Thanks,

Megan

[megan_mcp]

Hi Joe,

Is it okay if I access your server to see where the problem lies?

Thanks,

Megan

[megan_mcp]

Hi @bell

Is this a fresh instance you have just opened ?

Thanks,

Megan

[megan_mcp]

Hi @samsogade

Thank you for reporting this issue.

I have tested it and the issue has been resolved. Can you confirm this from your side?

Many thanks,

Megan

[megan_mcp]

@Saidharsan so glad you got sorted!

[megan_mcp]

Hi @Saidharsan

Your code seems to work fine for me. If you want to download your project.md file and send it to me via private message I can have a closer look?

Thanks,

Megan

[megan_mcp]

Can you send me a screenshot of your updated .f1.checkSensor function? This will allow me to assist you better🙂

[megan_mcp]

Can you make sure this dictionary exists within your .f1.checkSensor function.

[megan_mcp]

Hi @Joe

I believe the error was that badTrades.csv was saved to the wrong directory. I removed it from your database and the code seems to be running fine now.

Let me know if you have any further issues.

Thanks,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

Have you used .Q.dpft to save the lap table down to memory?

Thanks,

Megan

[megan_mcp]

Hi @bell

I’ve made a few adjustments. Can you try launching the capstone sandbox one more time? https://learninghub.kx.com/courses/kdb-developer-level-3/lessons/kdb-developer-level-3-capstone-project/

Remembering to run ./setup.sh in the terminal.

[megan_mcp]

I suggest you launch a fresh instance of the course.

If you have made any progress make sure to download your project.md file before completing the following steps:

Return to the terminal and run:

cd ..

Then run:

rm -rf course-advanced-capstone

Return here kdb Developer Level 3 Capstone Project – KX Learning Hub and click ‘Launch Capstone Sandbox’. Continue by following the README instructions again.

Let me know if this works!

Thanks,

Megan