New aspect - date for "grouping coordinates in knime with date"

Some time ago, I created the following topic “Grouping Coordinates in KNIME” - since that topic has been closed, I had to open a new one. I would like to add a temporal aspect to the subject mentioned above. Specifically, I want to know the number of days between the grouped coordinates. Simply put, I would need a minimum and maximum value and their difference. Is this possible? I have used the workflow by @Artem.

test3.xlsx (9.9 KB)

Hi @torres000,

tell me if I got your request right, this is what I’ve done:

  • I took Artem’s workflow and introduced new data: inside the Excel Reader node, I set the correct data format for the new columns (ie double and date)
  • I have used a GroupBy node to calculate the maximum and minimum dates for each cluster
  • I used a Date&Time difference node to compute the difference between the minimum and maximum dates of the GroupBy node.

Tell me if it works!

Have a nice day,
Raffaello Barri


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