Hi, when I run my code for question 1.3 (using a rack to complete a window join) the terminal errors and it removes the event and sensor tables from my process tab. The code was running correctly until now, but now it breaks the tables every time. I have tried to create a new workspace but when doing that, my workspace contents do not load. Any suggestions? Thanks.
Hi you can try these steps
If you want to share the code that caused the issue (use can use spoiler tag clicking 3 dots in toolbar) I can perhaps advise on why it caused the error so you can avoid it once you get a new workspace.
Hi Michaela, thanks for getting back to me! Tried the server steps but no luck. The show event works and presents table, then run the rack assignment, no error but tables disappear and afterwards, show event no longer runs without error. .f1.createLapTable:{[event;sensor]}
show event
rack: distinct select sensorId from sensor cross (select session,lapId,time,endTime from event);
w:(rack[time];rack[endTime]);
lap:wj[w;`sensorId`time;select from rack;(select from sensor;(avg;`sensorValue))];
show lap
show rack
Another user had issues with this function recently and i posted a sample answer which might help you debug
So it is being caused by a code error? Thank you!