Date time within time range

Hi @andrejz, glad it works for you.

Just as an additional option, I don’t know if you have python installed, and know SQL… but one of the common issues with general joining in KNIME is “range comparisons”. This can be overcome using SQL, and I put together a component a while back to assist in such situations.

In the attached workflow, I’ve added an example of my PandaSQL Join component. So here, it takes the dataset and performs a sql join between “all rows” and just the important event rows.

It provides some additional flexibility if all else fails! :wink:

Compare with previous event-python-pandasql alternative.knwf (28.9 KB)

The PandaSQL Join component is available here, but does need Python 3 installed.

3 Likes