Get a value from a disconnected table

[#1]

Hi, I have two tables like these:

Costs:

LOAD * Inline [

  Name,Cost,CostDate

  AAA,343,23/07/2014

  BBB,565,31/08/2015

  CCC,775,06/04/2011

  DDD,453,01/11/2015

  EEE,543,08/12/2009

  AAA,565,11/02/2013

  BBB,932,15/07/2012

  CCC,454,28/05/2010

];

IVA:

LOAD * Inline [

  Percentage,StartDate,EndDate

  16,01/01/1995,30/06/2010

  18,01/07/2010,31/08/2012

  21,01/09/2012,31/12/9999

];

How could I create a table like this?:

Name	Cost	CostDate	Percentage
AAA	343	23/07/2014	21
AAA	565	11/02/2013	21
BBB	565	31/08/2015	21
BBB	932	15/07/2012	18
CCC	454	28/05/2010	16
CCC	775	06/04/2011	18
DDD	453	01/11/2015	21
EEE	543	08/12/2009	16

What expression could I use in the last column?

Thanks in advance

[#2 · Accepted solution]

You can use IntervalMatch to join the date intervals.

[#3]

Check below post as reference.

Interval Match Feature/Function

[Gysbert_Wassenaar]

You can use the IntervalMatch function. See this blog post: IntervalMatch