Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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