[megan_mcp]

Hi @Jonathan

If you simply run:

q) s except .Q.A
"eifehisr"

This should work fine.

[megan_mcp]

Hi @Yu

When creating your tradeContext table are selecting from the trade table or a variation of the trade table that you have created yourself?

This is how I see some people get caught out, as the format of these manually created tables are incorrect.

Let me know!

Many thanks,

Megan

[megan_mcp]

Hi @lestat-jin

If you are still receiving the init.q evaluation error, restart your kernel and this should go away.

Thanks,

Megan

[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]

Maybe I’m understanding wrong, but if it’s a list of strings:

q)list: “wKDe arB33e on”, “I a quSesGREATt!”
q)list except .Q.A, .Q.n   //remove capitals and numbers
"we are on a quest!"

Or if you meant a list of lists:

q)list1: ("TpFcIc", "endkDg", "ZORkwh"), ("SjKvBM", "ioWzYM", "Ibuyjf")
q)list1 except .Q.A
"pccendkgkwhjviozbuyjf"

Apologies if I’m not understanding correctly. If you could provide a screenshot of an example, I would be happy to help.

Megan

[megan_mcp]

Hi @Yu

Sorry my mistake .. sorting the time by ascending order wasn’t the error.

In the exercise it states “This should have two extra columns – bid and ask”

I’ve noticed you have formatted your table to have your ask column before your bid column which has resulted in the formatting being incorrect.

I’ve tested your code by swapping the two columns and the test passed.

Hope this helps.

Megan

[megan_mcp]

Hi @Yu

`time xasc select option_id, time ..

Hope this helps!

[megan_mcp]

Hi @Yu

Can you try sorting time in ascending order? I realise this may not be obvious in the question itself so I will look in to adjusting this question for future users.

Thanks,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

I see your tables edge15, edgeProfile and optProfile all select data from different versions of the trade table e.g. trade06 or tradeWithAvgEdge which means the formatting of those tables may be off.

Try using just ‘trade’ instead of the adjusted versions.

Let me know if this works.

Thanks,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

Thank you for sending that over!

Your code seems to be correct so I’ll need to take a further look. Can I ask that you download your project.md file and send it to be at mmcparland@kx.com ?

Thanks in advance.

Best regards,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

Can you send me a screenshot of the meta for your edge15 table?

Also, the first 4 rows of your table should look like this – (screenshot attached)

Many thanks,

Megan

[megan_mcp]

Hi @hoffmanroni

Glad to hear you found a solution !

If you need help with any other questions, feel free to reach out 🙂

Many thanks,

Megan