Skip to main content
  • EN

Hello folks,

I want to split data from below data as shown.

 

I want the output format in CSV as this - 

where the target quantity is Quantity / No. of days in months.

The problem I am getting here is I am not able to split the data of month into number of dats because as I need the date as 01-Jan-25 for all the days in the month

How can iterate these values.

 

Kindly help!

Something like this?

  • Get the first day of the month as date
  • Calculate the number of days in each month
  • Calculate the quantity for each day of the month
  • Create a feature for each day in the month
  • Set the correct date in each feature
  • Cleanup

 

Hey ​@geomancer 

Thanks for the reply.

I think this is what I was looking for

I am not getting how to take the input data by using list exploder and attribute manager.

Can you please explain that.

I created some mock input data to illustrate how to process the data.

You should input your own data into the AttributeManager (instead of my mock data).

You will probably have to change some attribute names in the formulas.

Community Stats

31,788
Posts
120,757
Replies
39,405
Members

Latest FME

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.