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
    • geomancerEvangelist
    • 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

     

    1 Attachments
    liamfez
    1 person upvoted this
    • liamfez
      liamfez
    poonam21
    Contributor
    Forum|alt.badge.img+7
    • poonam21Contributor
    • 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
    • geomancerEvangelist
    • 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


    Most helpful members this week

    Community Stats

    30,845
    Posts
    116,936
    Replies
    38,670
    Members
    Terms & ConditionsCookie settings

    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
    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.