Skip to main content
Question

Split list of values to time periods

  • October 13, 2021
  • 3 replies
  • 35 views

nedwaterman
Contributor
Forum|alt.badge.img+9

CaptureI'm extracting some data from a DB that stores values for time periods against a date in a comma separated list (above).

 

I've used a cloner to create the time period for the date. Any idea how I split the csv list (presumably using an AttributeSplitter) and append the value to the desired timestamp?

 

Any help appreciated!

Thanks

 

 

 

 

3 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • October 13, 2021

I'd split the csv file into a list on the comma with an attributesplitter first, then explode the list and use the element index in a datetimecalculator to add the correct number of 15 minute increments

 

Capture


danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • October 13, 2021

I'd split the csv file into a list on the comma with an attributesplitter first, then explode the list and use the element index in a datetimecalculator to add the correct number of 15 minute increments

 

Capture

nice job!


nedwaterman
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • 69 replies
  • October 14, 2021

I'd split the csv file into a list on the comma with an attributesplitter first, then explode the list and use the element index in a datetimecalculator to add the correct number of 15 minute increments

 

Capture

Great solution - thanks very much!