Skip to main content
Solved

Split Data


poonam21
Contributor
Forum|alt.badge.img+7

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!

Best answer by geomancer

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

 

View original
Did this help you find an answer to your question?

3 replies

geomancer
Evangelist
Forum|alt.badge.img+46
  • Evangelist
  • Best Answer
  • March 5, 2025

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

 


poonam21
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • March 6, 2025

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.


geomancer
Evangelist
Forum|alt.badge.img+46
  • Evangelist
  • March 6, 2025

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.


Reply


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