To connect interval date with start and end date in the other table.

[Brownie]

This is the data i have in my excel 

And this is the required data that i want 

I want this done through interval match or any other rmethod if there's a possibility 

[Dalton_Ruer · Accepted solution]

Here is an example of how to do it. You can copy/paste into an app and then modify as needed for your structures. 

Data:
Load * Inline [
SalesID, Date, SalesAmt
1, 6/27/2020, 1203039
2, 6/28/2020, 1026330
3, 7/27/2020, 1149891
4, 8/27/2020, 9193930
];

IntervalData:
Load * Inline [
IntervalID, StartDate, EndDate
1, 6/1/2020, 6/30/2020
2, 7/1/2020, 7/31/2020
3, 8/1/2020, 11/14/2022
];

Intervals:
IntervalMatch (Date) Load StartDate, EndDate
resident IntervalData;

Join (Intervals)
Load
StartDate,
EndDate,
IntervalID
Resident IntervalData;

drop table IntervalData;