Home › Forums › KX Academy › advanced capstone project 1.4 › Reply To: advanced capstone project 1.4
-
Hi @Laura
below in my code snippet,
event1 : select from event where date <> first date sensor1 : select from sensor where date <> first date .f1.createLapTable1:{[eventTab;sensorTab] distinctSensors: distinct select sensorId from sensorTab; crosspdt:(select from eventTab) cross distinctSensors; windows:(crosspdt[`time;crosspdt[`endTime]); p:wj[windows;`date`sensorId`time;select from crosspdt;(select from sensorTab;avg;`sensorValue))]; }
lap: .f1.createLapTable1[event1;sensor1] show lap
.Q.dpft[`:/f1;2020.01.02;`sensorId;`lap]
while running .Q.dpft I am getting mismatched type error