Date Between

[ambasadorknz]

Hi,

I have some problem with check data in two tables..

Calendar:

DAY

2018/01/01

2018/01/02

2018/01/03

2018/01/04

Data1:

Start,End,Value

2017/10/01,2017/12/12,10

2017/12/12,2018/01/01/100

2018/01/01,2018/01/03/10

What i want to do is... check condition

if day is between Start and Sto then sum(Value)

It should looks like below table:

2018/01/01=110

2018/01/02=10

2018/01/03=10

2018/01/04=0

So Can You help me? Recommend some solution??

I need do all calculations/joins in Load statement    

Can i prepare one table X From Calendar and Data1?

[MK_QSL · Accepted solution]

check for intervalmatch() function

[ambasadorknz]

Thank You for Help...

I was looking for exactly that solution