Filtering fixed amount of rows by date

Hello

I’m a bit stuck, the previous implementation was to just extract a value each day that made filtering a lot easier.

I’ve also just started using KNIME a month ago with my colleagues having a 1 month headstart and they can’t really help.

I got the following data out of JDE E1 (already unpivoted):

All I can get is year and month when it comes to dates as E1 matches it with a work day calendar.

Now my issue is that E1 has cells 1-31 (WURU01-31) for each month, with unused cells being 0 (eg. February 30-31).

Weekends and holidays are also 0 so I’ll have to take those into account as well when it comes to counting weeks.

I’m trying to get the capacity per week, can’t use Chuck Loop with a interval of 7 because I got 31 “days” for every month.

I would need a solution to filter out the unneeded rows based on amount of days in a given month.

I could go an manually filter out the unneeded rows but I feel that I might have to create more reports in the future for different work centers so I’d like to have a more robust solution.

Thanks :slight_smile: