Skip to main content
  • EN

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

 

 

 

 

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

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!

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


Community Stats

30,176
Posts
114,542
Replies
37,835
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.