Error with join module

https://learninghub.kx.com/forums/topic/error-with-join-module

not sure if anything wrong with the data, but I had the below error when running the join notebook (no change made to original code, just following the notebook step by step)-- initialization was run fine and can see all data loaded... please see attached screenshot, thanks.

Hi @lestat-jin

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

Many thanks,

Megan

restarted kernel and didnt work....

I had a look at the data and it seems trade table is not defined, rather there is a trade_compressed table. could it be the reason since code referring to trade variable?see below screenshot,


thanks,

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

says couldn't find init.q file after the steps... not quite sure why as I can see them on terminals.

Hi @lestat-jin

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

Thanks,

Megan

Thanks a lot! guess my data is really messed up that the init.q cannot be run properly.