Calculate difference between dates within a group and get values from a corresponding column.

[Asghar]

Hi,
Here is the how the Input data looks like-

and the Output should look something like this-

The requirement here is, within a Group of n rows, if the difference between a Date and the other dates is 7 days or less then the value from ID column should be added to a new column (IDs).

It seems like I’ve to use Group Loop node here but I’m not sure which other nodes to use to get the results…
I started using Knime just last week.

Thanks…

[Daniel_Weikert]

date&time difference can get you the difference in days after you group your data with the loop

[HansS]

Hi @Asghar

Welcome to KNIME Forum.
And yes I think the GroupLoop is the way forward. I used it in combination with the Cross Joiner node to calculate the differences between all dates within a group. See this wf calc_difference_between_dates.knwf (42.5 KB)

gr. Hans

[Asghar]

ooooh… so that is how the Cross Joiner works…
Thank you so much @HansS