Question

Split list of values to time periods

  • 13 October 2021
  • 3 replies
  • 1 view

Badge +3

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

Badge +10

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

Userlevel 4
Badge +30

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!

Badge +3

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!

Reply