topic Re: Re: Intervalmatch in QlikView

Intervalmatch

Wed, 23 Oct 2013 09:13:39 GMT

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.

Wed, 23 Oct 2013 09:17:34 GMT

see attached file hope this helps you.

Wed, 23 Oct 2013 09:25:10 GMT

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

preminqlik — Wed, 23 Oct 2013 10:30:09 GMT

hi there,

PFA

hope it helps you

Gysbert_Wassenaar — Wed, 23 Oct 2013 11:03:45 GMT

Perhaps a load distinct?

LEFT JOIN (MasterTable)

IntervalMatch(Date, BridgeKey)

LOAD distinct Date_from, Date_to, BridgeKey

RESIDENT TempTable;