Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps a load distinct?
LEFT JOIN (MasterTable)
IntervalMatch(Date, BridgeKey)
LOAD distinct Date_from, Date_to, BridgeKey
RESIDENT TempTable;
hi
see attached file hope this helps you.
Thanks for your input, but I'm looking for a solution with just one table in the table viewer.
hi there,
PFA
hope it helps you
Perhaps a load distinct?
LEFT JOIN (MasterTable)
IntervalMatch(Date, BridgeKey)
LOAD distinct Date_from, Date_to, BridgeKey
RESIDENT TempTable;