topic Re: Interval Match in QlikView

Interval Match

Fri, 21 Oct 2016 18:17:55 GMT

Table 1

Table 2

Output Table

The Price_Alt value is the Min(Price_Alt) from Table 2 from the Date Period to which the Date field from Table1 belongs.

Not able to get the same using Interval Match

sunny_talwar — Fri, 21 Oct 2016 19:16:57 GMT

Try this:

Table1:

LOAD ProdcutId as ProductId,

Price,

Date,

Unit,

Sale

FROM

[https://community.qlik.com/thread/237306]

(html, codepage is 1252, embedded labels, table is @1);

Table2:

LOAD ProductId,

Price_Alt,

[Start Date],

[End Date]

FROM

[https://community.qlik.com/thread/237306]

(html, codepage is 1252, embedded labels, table is @2);

Left Join(Table1)

IntervalMatch(Date, ProductId)

LOAD [Start Date],

[End Date],

ProductId

Resident Table2;

Left Join (Table1)

LOAD *

Resident Table2;

Right Join (Table1)

LOAD ProductId,

Min(Price_Alt) as Price_Alt

Resident Table1

Group By ProductId;

DROP Table Table2;

Fri, 21 Oct 2016 19:40:49 GMT

That did the Job....Thanks Sunny!!!