Solved

Split Data

Forum|Forum|8 months ago
March 4, 2025
3 replies
56 views

+8

poonam21
Contributor

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.