Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Perhaps a load distinct?
LEFT JOIN (MasterTable)
LOAD distinct Date_from, Date_to, BridgeKey
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.
hope it helps you