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


      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.