I have flow data series in excel for every 10 secs for 5 years data, and i wish to convert that data into 1 hour data . can any one suggest what is best way to do in FME or any excel - without skewing my original data and output should make sense
Userlevel 2
+12
- Contributor
- 2177 replies
-
24 April 2018
I would try this workflow:
Read the data
Convert the timestamp to the previous hour (min and sec to 00).
Use the StatistcsCalculator transformer to get the result I need (sum, average, median, etc), using group by the hour.
Write the required output format.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.