Average Temperature based on Start Date and End Date

[Kris_Farwell]

I have data in two different files. File 1 contains Start and End Dates. File 2 contains Temperature readings every 10 minutes. I want to get the average temperature (and standard deviation) between start and end dates.

[usmanbashir]

@Kris_Farwell - Please see attached workflow. Note that your Input 1 and Output have slight variations in start and end dates on 2 lines, hence the slight differences in avgs/std dev. However this workflow should do what you need. 

Hope this helps!

[Kris_Farwell]

Your solution is very good however, file 1 has 28040 rows and file 2 has 12385 rows so using the append tool will result in 345 million rows. Is there a way to do this without using the append tool?

[usmanbashir]

@Kris_Farwell - Ahhhh. A batch macro that controls the filter is another option that won't require a join. 

[Kris_Farwell]

Do you have an example of this?

[usmanbashir]

@Kris_Farwell - See if this works. The macro will go through each Start/Date record one at a time (instead of everything all at once in previous workflow), then join to your list of dates, filter to records within the date range, then produce your metrics utilizing the summarize tool. 

Hope this helps!