Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to Qlikview
How to removing synthetic table from a Interval match ?
Plz help.
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
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
Hi,
You could Left Join the IntervalMatch Table onto Table 1
That's my number one guess...
Best,
Ali A
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,