Intervalmatch

[#1]

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.

[#2]

hi

see attached file hope this helps you.

[#3]

Thanks for your input, but I'm looking for a solution with just one table in the table viewer.

[preminqlik]

hi there,

PFA

hope it helps you

[Gysbert_Wassenaar · Accepted solution]

Perhaps a load distinct?

LEFT JOIN (MasterTable)

IntervalMatch(Date, BridgeKey)

LOAD distinct Date_from, Date_to, BridgeKey

RESIDENT TempTable;