Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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