[megan_mcp]

Hi @lonji3_1

Can you download your project.md file and send it to me at mmcparland@kx.com so I can have a closer look?

Thanks,

Megan

[megan_mcp]

The .viz.getModSensor function uses data from the sensor table.

You can either edit this function so that the runtime is quicker or apply an attribute to the table on disk (or both).

If you need any further assistance, please let me know.

Thanks,

Megan

[megan_mcp]

Hi @lonji3_1

There is no table called “raceTab”, it was the name given to the input parameter for raceDay.

When you ran Profile on .viz.createDashboard[] what function did you find took the longest to run?

Thanks,

Megan

[megan_mcp]

Hi @ckeogh1

I see you have received your certificate so congratulations on completing the course!

I’m assuming this issue was resolved?

Thanks,

Megan

[megan_mcp]

Hi @GC

You may want to save your answers as this will erase any code you have entered into the notebook.

But if you want to restart your server, go to File -> Hub Control Panel

Then click “Stop my Server” and “Start my Server”.

If this does not resolve the problem, please let me know.

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

If you are still having trouble with this exercise can I ask that you download your project.md file and send it to me at mmcparland@kx.com ?

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

The \l f1 command simply loads in the lap data from disk.

You must then preform your select statement for lapTable.

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

In exercise 2.3, it asks you to define a dictionary using the logic from the table above (screenshot below). This is missing from your function and is needed to be able to complete the functional code for benchmark and chk.

Can I ask that you include this and let me know the outcome?

Thanks,

Megan

• This reply was modified 2 weeks, 3 days ago by  megan_mcp.

[megan_mcp]

Hi @timbs_1995

It states in the exercise that you must load the lap table from disk.

To do we use the system command:

\l

**Tip: Instead of listing each individual column, you can simply run

select from lap

To retrieve the entire lap table.

Hope this helps!

Thanks,

Megan

[megan_mcp]

Hi @masmail

For question 2.3, you must convert the code that is provided within the .f1.checkSensor function into functional form.

So instead of the following select statement:

benchmark:select benchmarkValue:avg sensorValue by sensorId from lapTab;

It must be in the following format:

Functional Select

?[ table; whereConditions; groupBy; selectedColumns]

Let me know if this helps!

Thanks,

Megan

• This reply was modified 2 weeks, 3 days ago by  megan_mcp.
• This reply was modified 2 weeks, 3 days ago by  megan_mcp.

[megan_mcp]

Hi @masmail

I believe this error is due to the way you structured your .Q.dpft function.

If you take a look at the screenshot provided you will see that this namespace only accepts 4 arguments;

• d is a directory handle
• p is a partition of a database
• f is a field of the table named by t below
• t the name (as a symbol) of a simple table whose columns are vectors or compound lists

The first two parameters are correct [f1DbPath;2020.01.02, ..] however you need to take a look at the order of your second two.

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @lonji3_1

Try selecting a different column to apply the #p attribute to.

Thanks,

Megan

[megan_mcp]

Does it pass the tests anyway?

[megan_mcp]

Hi @timbs_1995

The table provided above is stating that there are 4 possibilities for the “mysensor” parameter: temp, tyre, wind or all.

If mysensor = temp then what should be returned are all the sensorId’s that include the word temp at the start. So tempBackLeft, tempBackRight, tempFrontLeft, tempFrontRight. The same applies for the rest.

If mysensor = all then all the sensorId’s must be returned.

You must create a dictionary that represents this logic.

Let me know if you have any further questions.

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

Sorry my mistake – you must add the name of the directory.

Which in this case is f1:

\l f1

Thanks,

Megan

• This reply was modified 2 weeks, 3 days ago by  megan_mcp.