4 Replies Latest reply: Oct 23, 2013 7:03 AM by Gysbert Wassenaar RSS

    Intervalmatch

    Erik van hout

      Hi Experts,

       

      I'm trying to join two tables using intervalmatch, however as my interval isn't unique the result isn't what I'm looking for.

      I've made an example-script in which you can see the outcome:

        4 records have been create in my MasterTable (where I'd just like the two records shown in the table box)

       

      How can I make sure each type will only be joined once?

       

      In the example the date_from and the date_to are exactly the same.

      This will not necessarily be the case.