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
Question
FME and excel
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
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.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.