New to the KNIME platform. I have just started to understand the tooling however I’ve been stuck on a task for several days and need some help.
I have two tables, and I am wanting to compare the dates between them. Example of my tables below:
So, for example in “Date Stay” I want to compare the date in row0 to every date in “Date Change”. And I want to determine the difference between dates (e.g. 6M 10 days) and store the results in a new column.
Hello @emily_memko and welcome to the KNIME community
You can test ‘Cross Joiner’ node; this node will avoid loops and increase performance:
P.S. ‘Rule-Engine’ or ‘Rule-based Row Filter’ node comparing columns, will do the final job.
As @gonhaddock suggested you could try crossjoiner and then Date&Time difference node
Thank you for that suggestion, works exactly how I want. I never even looked into that node.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.