# Dividing and splitting rows

**URL:** <https://forum.knime.com/t/dividing-and-splitting-rows/11381>\
**Category:** KNIME Analytics Platform\
**Created:** [June 25, 2018, 2:32pm UTC](https://forum.knime.com/t/dividing-and-splitting-rows/11381 "2018-06-25T14:32:16Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [July 10, 2018, 6:14pm UTC](https://forum.knime.com/t/dividing-and-splitting-rows/11381/5 "2018-07-10T18:14:46Z")

</div>

I constructed a workflow that illustrates how you could do it. Basically you

- first do it like in the example above you count down from the original TargetDay
- the you expand the possible TargetDays by factor 3 (so you will have enough days once you start eliminating some in-between)
- then you mark all days that are not suitable like holidays and weekends
- the remaining ones you just join back by an iteration number and voila you have the new TargetDays

 ![19](https://forum-cdn.knime.com/uploads/default/original/2X/d/d7c227d9254b258921d932538c7c197fbc4bf1fa.png)

the yellow marked columns state why this day could not be used (Easter in this case). And the green column is the one with the new TargetDays

 ![52](https://forum-cdn.knime.com/uploads/default/original/2X/6/6eb2d3c2f5ac58972ebb9226407380ccfa6048fc.png)

I constructed a separate workflow that extracts holidays for a given year from a website. But you could also use your own list. And for some countries you would have to decide if it is really a holiday where offices would be closed.

 ![19](https://forum-cdn.knime.com/uploads/default/original/2X/d/db4a631be278d22fd69626cd294810eaac9199a3.png)

[kn\_example\_extract\_holidays.knwf](https://forum-cdn.knime.com/uploads/default/original/2X/a/a0c16386d4a55d9e712cdd060aac9bdb8a092b64.knwf) (150.6 KB)

[kn\_example\_split\_tasks\_into\_days.knwf](https://forum-cdn.knime.com/uploads/default/original/2X/3/38e08ebadb63c55fd0451f49a95ef23c9efa73cc.knwf) (211.2 KB)

---

_[View the full topic](https://forum.knime.com/t/dividing-and-splitting-rows/11381)._