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
Page 1 / 1
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.