Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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

View solution in original post

4 Replies
Not applicable
Author

hi

see attached file hope this helps you.

Not applicable
Author

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

preminqlik
Specialist II
Specialist II

hi there,

PFA

hope it helps you

Gysbert_Wassenaar

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

View solution in original post