• KX Academy

  Advanced Capstone 1.3 test fial.

  Posted by Kenan on April 10, 2024 at 5:49 am

  I am failing the test in question 1.3. I don’t understand where I am making a mistake. My code with the schema and count of my lap table:

   

  .f1.createLapTable:{[eventInput;sensorInput]
  
  uniqueSensor: distinct select sensorId from sensorInput;
  
  rack:(select from eventInput) cross uniqueSensor;
  
  w:(rack[`time];rack[`endTime]);
  
  f:wj[w;`date`sensorId`time;select from rack;(select from sensorInput;(avg;`sensorValue))];
  
  f:select date,session, lapId, time, endTime, sensorId, sensorValue from f;f
  
  }

   

   

  Screenshot-2024-04-06-182303-2.png 4 KB Image File - Click to view

  Options

  • Copy Download Link

  Kenan replied 7 months, 2 weeks ago 3 Members · 4 Replies
• 4 Replies

• 

  megan_mcp

  Administrator

  April 10, 2024 at 10:39 am

  Hi @kenan_davidsonyahoo-com

  I’ve took a look at your ‘.f1.createLapTable’ function and I’ve made a few adjustments:

  .f1.createLapTable:{[eventInput;sensorInput]

  uniqueSensor: distinct select sensorId from sensorInput;

  rack:(select from eventInput) cross uniqueSensor;

  w:(rack[`time];rack[`endTime]);

  f:wj[w;`date`sensorId`time;select from rack;(select from sensorInput;(avg;`sensorValue))];

  delete date from f

  }

  • To retrieve a column from a table you must use bracket notation with a backtick as follows – w:(rack[`time];rack[`endTime]); *Example provided below*

  • It states in the .f1.createLapTable function template that it wants a table returned with the following columns: `session`lapId`time`endTime`sensorId`sensorValue. Hence why the delete statement for date was included at the end.

  If you have any questions please let me know!

  Thanks,

  Megan

  

  
  • 

    Kenan

    Member

    April 11, 2024 at 9:46 am

    Thank you for your help! But after editing 1.3 I was able to pass all sections but when I try and submit I recieve an error for 1.4 and 1.5.

    

    Screenshot-2024-04-10-173923.png 79 KB Image File - Click to view

    Options

    • Copy Download Link

    

    Screenshot-2024-04-11-024520.png 40 KB Image File - Click to view

    Options

    • Copy Download Link
    • 

      pmurphy

      Member

      April 11, 2024 at 2:46 pm

      Maybe your lap table still had a date column when it was saved to disk and the column is interfering with the tests?

      You could try redefining the lap table and running .Q.dpft and .Q.chk again

      • 

        Kenan

        Member

        April 11, 2024 at 7:00 pm

        It was how I answered 2.2, I added the date col back to the laptable causing 1.4 and 1.5 to fail after completeing question 2.

        Thanks

Log In to Reply