GitHub user lionants02 added a comment to the discussion: Using Hop to transform data and write to another database
For the daily summary data, I use "Select values" in the "Meta-data" tab to convert the time field into a "String" in the desired counting format, such as "yyyy-MM-dd" in this case. Then I sort this field from smallest to largest using "Sort rows" and perform a "Group By sum" using the fields created from "yyyy-MM-dd". This method allows you to adjust the resolution from daily to hourly by adjusting the "yyyy-MM-dd HH" format to your desired level. GitHub link: https://github.com/apache/hop/discussions/6308#discussioncomment-15592731 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
