Interval Match (Extended)- Need Help *Urgent

koushik_roy2 — Wed, 02 Dec 2015 09:24:40 GMT

Hi All,

I am having a issue when trying to write Interval Match.

I have two tables in my script.

Table 1:

And I have a table like below-

Table 2:

I need to create a new table like below-

Desired Table:-

%Period	START PERIOD	END PERIOD	EMP_ID
201101	201101	201201	1023
201101	201101	201202	1023
201101	201101	201203	1023
201101	201101	201204	1023
201101	201101	201205	1023
Upto the Last Period	....	....	....

Please help me out because its very urgent.

Regards,

Koushik.

topic Interval Match (Extended)- Need Help *Urgent in QlikView