community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Splitting of data based on dates

Highlighted
Meteor

Hi all i have a data set as like shown in the image 1:

table.JPGImage 1

But I need as split wise based on the month

as shown in image 2:

table2.JPGImage2

Attached excel file for reference.

Regards,

Yoganantha Prakash G P

Aurora

Hi @Yoga321 

 

WF.png

 

Like most workflows that work with date ranges, the easiest way to solve this is to generate all the dates between the start and the end and then group them to extract monthly start and end dates

 

Results.png

 

As long as you have less than 1M entries to process this should work fine.  More than 1M and you may run into memory issues since the Generate rows can produce very large record sets.  If you have more than 1M records to process you'll need a date range based solution that doesn't  expand your input data set.

 

Please note that you had an incorrect value in your excel sheet.  Your Apple start date was 2019-12-25 

 

Dan

Labels