My database is >13.000 points from 6 different vessels. I need to create lines for each day, for each vessel. The lines have to be created in chronological order. I'm trying to group the dates after sorting, for then build the line using both datetime and vessel name parameters. I have converted date time format (ex 20210415165357, which is YYYYMMDDHHMMmm) to 2021-04-15 (YYYY-MM-DD). Any ideas how to solve this?
Question
how to group points by datetime and/or group id , in order to build line in a specific sorter?
+51- Celebrity
- 2077 replies
Olá Marina, tudo bem?
DId you use the Sorter transformer before ?
Se quiser me enviar por email o Workspace, pode enviar.
Thanks in Advance,
Danilo
+56- Safer
- 2554 replies
I think either the TimeWindower transformer or the DateTimeExploder transformer will help you to group data by dates. I made this my question-of-the-week and recorded a video of me trying to solve it. You can find the video here: https://www.youtube.com/watch?v=PleftCrodJk&t=260s
I hope you find this useful.