I have a script in which a Table from a database ([TimeStamp],[DataName],[Value]) is loaded using the generic load. The Table is large and causes a long loading time. On top of that in a certain script it also causes a crash. I would like to pick several entries and not load those, I don't need. This is a part of the script:
LOADFloor(Timestamp) as%Datum, Dataname, Sum(Value) asValue GroupByTimestamp, Dataname ; SQL SELECT Timestamp, Dataname, Value FROM MySource;
A calander follows which I left out for better clarity. Do you have any idea how to solve the problem. Thank you in advance.