Home › Forums › KX Academy › Advanced Capstone 1.3 test fail. › Reply To: Advanced Capstone 1.3 test fail.
-
.f1.createLapTable:{[eventInput;sensorInput]
uniqueSensor: distinct select sensorId from sensorInput;
rack:(select from eventInput) cross uniqueSensor;
w:(rack[
time];rack[
endTime]);f:wj[w;
sensorId
time;rack;(select from sensorInput;(avg;`sensorValue))];f:select date, session, sensorId, lapId,time,endTime,sensorValue from f;f
}
My lap count and schema.