[megan_mcp]

Hi @hoffmanroni

Glad to see your issue was resolved! If you have any other issues please feel free to let us know.

Thanks,

Megan

[megan_mcp]

Hi @jpandza

So after running the ./setup.sh command in the terminal, go back to Launcher and click ‘KX Developer’.

This will launch an instance of the capstone titled ‘funds_capstone’. Open this up and inside you will find the the project.md file. All code must be ran within the scratchpad or the rendered markdown file for you to pass.

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

Many thanks,

Megan

[megan_mcp]

Hi @jpandza

When you say you ran “ps -ef | grep 5010″ in the terminal, can you share a screenshot of where exactly ?

All code should be ran in KX Developer, in either the scratchpad or the rendered markdown file.

Many thanks,

Megan

[megan_mcp]

Hi @lestat-jin

There are a few tables such as trade_compressed, marketData and t that shouldn’t be a part of that module.

My thinking is that your instance has been overwritten with another courses data.

If you want a fresh instance of the Joins module, return to the terminal and run:

cd ..

Then run:

rm -rf course-advanced

Return to the course on the academy and click ‘Launch KX Sandbox’.

Let me know if this works!

Many thanks,

Megan

[megan_mcp]

Hi @Mohamed

Sorry to hear you are experiencing issues with our Sandbox!

Does this occur when you hit the ‘Launch KX Sandbox’ button on the academy or when you try to launch KX Developer?

Can you provide me a screenshot of your screen when this issue occurs?

Many thanks,

Megan

[megan_mcp]

Hey Josh!

There should be an easy fix for this:

Go to File -> Hub Control Panel

Then click “Stop My Server” and “Start My Server” again.

If this doesn’t fix the issue, please let me know🙂

Thanks,

Megan

[megan_mcp]

Hi @lestat-jin

Have you tried restarting your kernel ? If this does not work, please let me know🙂

Many thanks,

Megan

[megan_mcp]

Hi @bimangunarathne

I have tested your query and it seems to work fine. Can you send me a screenshot of the error you are receiving?

Many thanks,

Megan

[megan_mcp]

Hi Josh,

Once you have launched the KX Sandbox, you must click the blue button in the top right-hand corner and go to Terminal (screenshot below).

Within terminal, run the command ./setup.sh

Once this is ran, navigate back to launcher and click “KX Developer”

This should launch an instance of KX Developer where you will then see your “funds_capstone” project file.

If you have any issues/questions please feel free to let me know🙂

Thanks,

Megan

[megan_mcp]

Hi @bimangunarathne

I can understand your confusion as you should not be using lowercase letters or symbols as they will produce the wrong answer (I will have this updated).

Take a look at the Tok operator instead – Tok interprets string data to another datatype | Reference | kdb+ and q documentation – kdb+ and q documentation (kx.com)

Many thanks,

Megan

[megan_mcp]

Hi @gtg944s

Can you provide me with a few extra details about this or provide a screenshot of where you are having issues?

Have you ran the ./setup.sh file from the terminal ?

Are you unable to run code within KX Developer?

Thanks,

Megan

[megan_mcp]

Hi @bimangunarathne

By running this line of code, you are searching for the messages.csv file in your current directory. You need to provide a file path to which your message.csv file currently sits in.

It states in the project the location of the directory (screenshot below).

As it is saved to variable csvPath, you can use that.

If you have any questions, please feel free to let me know 🙂

Thanks,

Megan

[megan_mcp]

Hi @lestat-jin

The correct way to execute your answer would be to remove the square brackets:

{8>count x}{x,sum -2#x}\0 1

This is because we are looking for the dyadic form of the scan adverb ‘x f\y’. Which if I use a parse tree to explain, would look like this:

q)-5!"{8>count x}{x,sum -2#x}\\0 1" / the correct version
(\;{x,sum -2#x})       
{8>count x}            
0 1                    

However if you use square brackets after scan, it forces it into monadic scan form, ‘x[f\y]’:

q)-5!"{8>count x}{x,sum -2#x}\\[0 1]"
{8>count x}
((\;{x,sum -2#x});0 1)

If you have any questions on this, please let me know!

Thanks,

Megan

[megan_mcp]

@bimangunarathne

[megan_mcp]

Try replacing this part of your code:

0: `$”:message.csv”

With this:

0: `$csvPath;