Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jonesbrown
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
sunny_talwar

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
sunny_talwar

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

bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,

You could Left Join the IntervalMatch Table onto Table 1

That's my number one guess...

Best,

Ali A

kfoudhaily
Partner - Creator III
Partner - 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,

QlikView Qlik Sense consultant