Calculate max. tim in row for timetable

Hi @tschaipi and welcome to the KNIME community.

If I have understood correctly, you want to find the first n films from your sorted data which together have a running time of up to 1080 minutes. Is that what you meant?

If that is the case, then you need to create a new column containing the cumulative sum of the runtimes, which can be performed using the Moving Aggregation node. This will give the cumulative run times for each film from first to last. Then you could use a Row Filter to return just those rows where the cumulative run time is between 0 and 1080.

An example of Moving Aggregation to calculate the cumulative sum can be found here:

I hope that helps

3 Likes