Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Intervalmatch

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Intervalmatch

Perhaps a load distinct?

LEFT JOIN (MasterTable)

IntervalMatch(Date, BridgeKey)

LOAD distinct Date_from, Date_to, BridgeKey

RESIDENT TempTable;


talk is cheap, supply exceeds demand
4 Replies
Not applicable

Re: Intervalmatch

hi

see attached file hope this helps you.

Not applicable

Re: Intervalmatch

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

preminqlik
Valued Contributor II

Re: Re: Intervalmatch

hi there,

PFA

hope it helps you

MVP & Luminary
MVP & Luminary

Re: Intervalmatch

Perhaps a load distinct?

LEFT JOIN (MasterTable)

IntervalMatch(Date, BridgeKey)

LOAD distinct Date_from, Date_to, BridgeKey

RESIDENT TempTable;


talk is cheap, supply exceeds demand