Skip to main content
Question

Split list of values to time periods


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+38
  • Influencer
  • 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
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • October 13, 2021
ebygomm wrote:

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
  • October 14, 2021
ebygomm wrote:

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!


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