Interval Match Problem

[kushalthakral]

Hi All

i have a requirement to get results from two tables through interval match function. Below are two sample tables

1. 

Date	Brand	Value
5/27/2019	AC	100
7/15/2019	AC	80
1/4/2019	AC	100
8/4/2019	AC	100
4/15/2019	AC	100
4/22/2019	AC	100
4/29/2019	AC	100
5/6/2019	AC	100
5/13/2019	AC	100
5/20/2019	AC	100
3/6/2019	AC	100
10/6/2019	AC	100
6/17/2019	AC	100
6/24/2019	AC	100
1/7/2019	AC	100
8/7/2019	AC	100
7/22/2019	AC	100
7/29/2019	AC	100
5/8/2019	AC	100
12/8/2019	AC	100
8/19/2019	AC	0
8/26/2019	AC	0

2. 

SENDER	Sub Brand Name	Amount	Start Date	End Date
AC	A	1000	6/1/2018	12/31/2099
AC	B	200	6/1/2018	12/31/2099
AC	C	300	6/1/2018	12/31/2099
AC	D	4000	6/1/2018	12/31/2099
AC	E	5000	6/1/2018	12/31/2099
AC	F	6000	6/1/2018	12/31/2099
AC	G	7000	6/1/2018	12/31/2099

Based on interval match i need to get Brand wise Amount for a particular date that lies in start date and end date

Thanks

Kushal

[rubenmarin]

Hi Kushal, intervalmatch is used when there are diferent date ranges to apply values, in this case all rows from table 2 has the same dates, maybe you only need a join to have all values from table 1 splitted into all values from table 2 (where Table1.Brand=Table2.SENDER)

[Brett_Bleess]

Kushal, likely going to need QVW file on this one in order to get some further comments, as folks likely want to see your data model etc. as well in order to try to see exactly how you are doing things.

Regards,
Brett