Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to removing synthetic table from a Interval match ?

Hi All,

I am new to Qlikview

How to removing synthetic table from a Interval match ?

Plz help.

1 Solution

Accepted Solutions
Highlighted

First of all, as per HIC it is not a bad thing to have synthetic key created by interval match function

IntervalMatch

Capture.PNG

But if you still feel like removing it... you can join the three tables together (Table1, Table2, and Interval Match table) into one table

View solution in original post

3 Replies
Highlighted

First of all, as per HIC it is not a bad thing to have synthetic key created by interval match function

IntervalMatch

Capture.PNG

But if you still feel like removing it... you can join the three tables together (Table1, Table2, and Interval Match table) into one table

View solution in original post

Highlighted
Partner
Partner

Hi,

You could Left Join the IntervalMatch Table onto Table 1

That's my number one guess...

Best,

Ali A

Highlighted
Creator III
Creator III

it actually depends on your data model and your use.

here is a good article about the fonction with qvw exemple: Interval Match Feature/Function

here is an exemple of interval match I have used in the past without syntetic key in the model: Re: Match multi value fields

You can also provide a data sample, we might be more helpfull.

regards,