Date Mapping through Date intervals

KNIME Analytics Platform
1

Hello,

I want to map week number using date intervals.

image

If the date falls in between any of the intervals in mapping that is from “Start” to “End” then I want that Week Number to get assigned for that particular date.

Thanks in advance.

2

have you thought about using the:

to extract the week numbers or do you want to use your own definition.

BTW: welcome to the KNIME forum :slight_smile:

5 Likes
3

Starting with what @mlauber71 suggested, I would do something like this:

  1. Convert your dates from string to KNIME date format
  2. Extract the day of year from the date, as well as the start and end
  3. Cross join the two tables
  4. Use a Rule-based Row Filter to keep only the records where the day of year for the date falls between the day of year for start and end

A bit clunky due to the cross join, but it should work.

3 Likes
4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.