topic How to removing synthetic table from a Interval match ? in QlikView

How to removing synthetic table from a Interval match ?

jonesbrown — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to Qlikview

How to removing synthetic table from a Interval match ?

Plz help.

sunny_talwar — Thu, 02 Aug 2018 11:22:01 GMT

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

bwisealiahmad — Thu, 02 Aug 2018 11:22:24 GMT

Hi,

You could Left Join the IntervalMatch Table onto Table 1

That's my number one guess...

Best,

Ali A

kfoudhaily — Thu, 02 Aug 2018 11:52:43 GMT

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,