Reply To: advanced capstone project 1.4

[harshit-raghuvanshi]

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