topic Re: Need Help in QlikView

Need Help

paulwalker — Wed, 09 Sep 2015 16:08:01 GMT

Hi Community,

Please any one can explain brief Extended Interval Match??

Thanks in Advance..............

Re: Need Help

Gysbert_Wassenaar — Wed, 09 Sep 2015 16:33:01 GMT

Can you tell us what you don't understand after searching for and reading discussions about this subject? https://community.qlik.com/search.jspa?q=intervalmatch+extended

Re: Need Help

paulwalker — Wed, 09 Sep 2015 16:48:03 GMT

HI Gysbert,

I have read blogs.. but I am little confusion

Ans1:

Extended Interval Match is used when you have more keys like Primary and Foreign Key Relation (apart from just Startdate/Enddate) to be matched. So, it does not reduce the number of joins..

Ans2:

Some blogs written Extended Interval Match only for SCD (Slowly Changed Dimension)

Which one is Correct????

Re: Need Help

Gysbert_Wassenaar — Wed, 09 Sep 2015 16:53:43 GMT

The extended syntax for intervalmatch does not reduce the number of joins. Intervalmatch doesn't join tables. The JOIN keyword is used to join tables.

Intervalmatch can in some cases be used to deal with slowly changing dimensions. But there are other ways. And intervalmatch (with or without extended syntax) can be used for other problems too.

Re: Need Help

paulwalker — Wed, 09 Sep 2015 16:59:09 GMT

Thanks for Clarification...