Search results
-
H
Workaround Question
Hello, I have a question about a query, here's the data: Dataloggerkey Timestep 977 6 977 8 977 10 977 82 888 10 888 4 888 12 In the query I'd like to have: Select... -
H
Iteration
Hello, I have a script that is designed to find the most previous TimeAndDate for each record. I need to run this script for thousands and/or millions of DataLoggerKeys. The way the script runs now, it runs out of resources pretty quickly. Can somebody offer a suggestion as to how I can edit... -
H
DateDiff between Rows
Is it possible to have a Datediff function compare the minutes between consecutive rows in a Time column? Example: Primary____________Time____________TimeStep 1_________________0100____________N/a 2_________________0102____________2 3_________________0108____________6... -
H
Query involving multiple sources
I have data collected from on-site data loggers that I need to analyze. I have run a query to sort DataLoggerKey from AreaTypeTable based on the classification of the Area type that the logger was installed in. From this query I have a list of unique DataLoggerKey entries. I want to query...