Discussion board where members can get started with QlikView.
I am new to Qlikview
How to removing synthetic table from a Interval match ?
First of all, as per HIC it is not a bad thing to have synthetic key created by interval match function
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
You could Left Join the IntervalMatch Table onto Table 1
That's my number one guess...
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.