Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get a value from a disconnected table

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?:

    

NameCostCostDatePercentage
AAA34323/07/2014 21
AAA56511/02/2013 21
BBB56531/08/2015 21
BBB93215/07/2012 18
CCC45428/05/2010 16
CCC77506/04/2011 18
DDD45301/11/2015 21
EEE54308/12/2009 16

What expression could I use in the last column?

Thanks in advance

1 Solution

Accepted Solutions
Not applicable
Author

You can use IntervalMatch to join the date intervals.

View solution in original post

3 Replies
Not applicable
Author

You can use IntervalMatch to join the date intervals.

Not applicable
Author

Check below post as reference.

Interval Match Feature/Function

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand