Skip to main content
  • EN

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?

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

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


Community Stats

30,168
Posts
114,527
Replies
37,825
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.