Fill up number ranges

[KasimirNepomuk]

Hello there,

I have the following problem: I have to numbers in two columns and I want to extract everey single number between these numbers, for example:

The expected result is the following:

So a column, where I have every number in between the columns, but not those not between the columns, so not 1988, which would not be in the range of the above numbers.

To summarize: I basically want a way to fill up the values between a range of different values.

Does someone have an Idea as how to solve this?

[MartinDDDD]

Hey there,

many different ways to achieve this in KNIME - here’s one without need to loop using One Row To Many Node (one of my secret favourites )

Workflow:

FillUpNumbers.knwf (85.6 KB)

[KasimirNepomuk]

Thank you very much! This worked