Skip to main content
Question

how to group points by datetime and/or group id , in order to build line in a specific sorter?


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?

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • March 25, 2022

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


mark2atsafe
Safer
Forum|alt.badge.img+47
  • Safer
  • March 28, 2022

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings