Removing synthetic keys when using Interval Match

Tue, 29 Nov 2011 00:08:29 GMT

Hi All,

I am using an interval match function and this is leading to the formation of synthetic keys, which I believe is creating a great performance issue. I saw a couple of post on this already but not able to get a correct solution.

So , I have a table Table1 which has inline data and 3 fields:

Table1

LOAD * INLINE [

StartRange, EndRange, DateRange

09/27/2004, 09/25/2005, FY-05

09/26/2005, 09/24/2006, FY-06

09/25/2006, 09/30/2007, FY-07

];

and I'm using an interval match function like this

IntervalMatch(Calendar.DATE) Load StartRange, EndRange Resident Tabel1;

So, just using the calendar date to interval match with the inline data table above. But this results in a synthetic key formation which I need to remove. Any recommendations.

Thanks in advance.

Removing synthetic keys when using Interval Match

johnw — Tue, 29 Nov 2011 00:21:37 GMT

Left join the intervalmatch onto Table1 would be my first guess.

Removing synthetic keys when using Interval Match

Tue, 29 Nov 2011 00:46:51 GMT

It worked . Thanks a lot John.

Re: Removing synthetic keys when using Interval Match

Anonymous — Sun, 18 Dec 2016 17:03:27 GMT

Thats correct answer. Thank you

topic Removing synthetic keys when using Interval Match in QlikView

Removing synthetic keys when using Interval Match

Removing synthetic keys when using Interval Match

Removing synthetic keys when using Interval Match

Re: Removing synthetic keys when using Interval Match