Can you help suggest on how to implement intended input/output shown below? Thanks
I was thinking of something like this identify_months.knwf (68.2 KB)
It works for dates within one year. If you have records from more than one year you have to extend the calendar data, and the logic.
Hope this helps!
I “borrowed” @HansS great solution and tried a different way.(What i do not like is that I had to manually sort the columns at the end) Kudos to @HansS
Thank @HansS and @Daniel_Weikert ! Highly helpful
Just in case folks from the future (including myself) are looking for an alternative solution, I’ll park my workflow here:
- Solution without loops to suit large datasets. (Won’t have to wait to iterate each individual row)
- For a longer period range where the end date may not fall within the same year, months that appear more than once are marked accordingly.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.