Interval match question by a novice..

mr_novice — Thu, 15 Nov 2012 13:54:10 GMT

Hello all,

I have two tables:

Table1

%Key_Model, Number, Model, FromDate, ToDate

1,123456, Model1, 2012-01-01, 2012-01-31

2, 123456, Model2, 2012-02-01, 2012-04-30

3, 123654, Model3, 2012-03-01, 2012-12-31

... and so on

Table2

Number, Date, Fact

123456, 2012-01-01, 1

123456, 2012-02-10, 1

123654, 2012-02-11, 5

...and so on..

I would like to create a table like this.

Resulting table:

%Key_Model, Number,Date, Fact

1,123456, 2012-01-01, 1

2, 123456, 2012-02-10, 1

3, 123654, 2012-02-11, 5

I want my resulting table to contain the %Key_Model from table1 but only where the event from table2 is between the dates in table1.

Do you have any suggestions?

cristian

topic Interval match question by a novice.. in QlikView