Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use IntervalMatch to join the date intervals.
You can use IntervalMatch to join the date intervals.
Check below post as reference.
You can use the IntervalMatch function. See this blog post: IntervalMatch