[megan_mcp]

Hi ,

If you take a look at the screenshot provided below, the question states to extract all the unique instruments so this would indicate to use the inst_id – not the option_id.

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

Megan

[megan_mcp]

Hi ,

Here are some hints to help simplify your function:

count each `. tables[] – returns the number of rows in each table

list1 ! list2 – joins these two lists together to create a dictionary

If you are still stuck let me know,

Megan

[megan_mcp]

Hi  !

Can I ask you to send over the code you’re trying to run?

Thanks,

Megan

[megan_mcp]

Hi ,

Assuming you’re getting the error ‘trips’ is because you haven’t imported the trips.csv file in yet which is mentioned in the “Importing Data using KX Developer” section of the demo (screenshot provided).

Once you’ve imported this csv file, it should be able to run as expected.

Let me know if this works,

Megan

[megan_mcp]

Hi  !

From what I can see your .z.pg code works fine. The issue, as you mentioned, is your code for loading in the database.

Can you try replacing your lower two hdbH statements with:

hdbH"\l f1"

hdbH"tables[]"

Line 1 is what the user described in the post you tagged – ‘l’ meaning load and ‘f1’ being the directory.

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi  !

Can you try naming the function classifyTrades instead of classifyTrade.

I’ve tested it and it should work fine with this adjustment.

Many thanks,

Megan

[megan_mcp]

Hi  !

I’ve tested your code and the only issue I can see is that you need to change the spelling of the symbol from:

`notAuthorised

To:

`notAuthorized

As stated in the question (screenshot provided below).

Let me know if this works!

Megan

[megan_mcp]

Hi  !

If you try putting a forward slash between the edit and the hashtag, it should go into editor mode.

Let me know if this works!

Megan

[megan_mcp]

Hi  !

From what I can see the problem is in line 3. If you replace:

.Q.trp[{`$(mysensor),

With:

'string[mysensor],

Your function should work fine.

If you have any other issues please feel free to let me know,

Megan

[megan_mcp]

Hi ,

That screenshot shows you are still in JupyterLab. Once you’ve ran the script in the terminal, click the Launcher tab (blue button in the top left hand corner), then click KX Developer (screenshot provided).

Once KX Developer has launched, you’ll be greeted with your workspaces where you should see your kxsql-demo workspace.

Hope this helps,

Megan

[megan_mcp]

 

I notice for your uniqueOpts variable you’ve declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec  keyword.

Once you’ve edited this, it should work fine.

Thanks,

Megan

[megan_mcp]

 

It looks like you are trying to send an IPC query from the database to the database which is not supported. It is unclear where you are running it.

If that is a data source in a dashboard, that code is getting shipped to a DAP and then it is trying to query itself, which is not supported.

Megan

[megan_mcp]

Hi ,

Sorry for the delay in response, it’s because you didn’t define your function as ‘classifyTrades’.

I defined the function and the tests passed.

Thanks,

Megan

[megan_mcp]

Hi  !

Unfortunately, at the moment there’s no way to achieve this, the reason being that it would overcomplicate the already complicated datagrid configuration.

However I do recommend using dataform to edit the values for single selected row.

Thanks,

Megan

[megan_mcp]

Glad to hear! Goodluck with the rest of the Capstone. Megan