I have two tables. The tables both show: the Wellname, the Well ID, Start DateTime, End DateTime, and a comment. Both tables can have multiple rows for each well.
Essentially, I am trying to see if the date ranges from Table Number 1 are included in the date ranges in Table Number 2. If the date range in Table Number 1 does not fall in the date range of Table number 2 (at least partially), kick this row out to a report.
I have been scratching my head on this problem for a while now. Please let me know if you can help.
If it makes it easier, I can create a "Source" column in both tables and then concatenate them into one individual table. If this was only one well, I know that I could use the binner dictionary node.
However, the issue is that there are multiple wells and the date ranges from table number 1 may fall in multiple date ranges in table number two.