KX Academy

Advanced Capstone 1.3 test fail.

Posted by Kenan on April 4, 2024 at 12:19 pm

I don’t understand why my 1.3 test is failing. Please find a copy of my code and a picture of my test results attached.

Thanks.

.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;rack;(select from sensor;(avg;`sensorValue))];
f:select session, sensorId, lapId,time,endTime,sensorValue from f;
f

}

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

3 Replies

Laura

Administrator
April 5, 2024 at 11:25 am

Hi,

Within your window join, you are selecting from sensor instead of the sensorInput parameter you’ve passed into the function. This could be what is creating incorrect values in your table.

Hope this helps!

Laura
Kenan

Member
April 5, 2024 at 11:26 pm

I edited my wj to select the sensorInput but my code still fails the test.
- Kenan
  
  Member
  April 7, 2024 at 1:23 am
  
  .f1.createLapTable:{[eventInput;sensorInput]
  
  uniqueSensor: distinct select sensorId from sensorInput;
  
  rack:(select from eventInput) cross uniqueSensor;
  
  w:(rack[time];rack[endTime]);
  
  f:wj[w;sensorIdtime;rack;(select from sensorInput;(avg;`sensorValue))];
  
  f:select date, session, sensorId, lapId,time,endTime,sensorValue from f;f
  
  }
  
  My lap count and schema.

KX Community

Advanced Capstone 1.3 test fail.

Laura

Kenan

Kenan