The intervalmatch works, but it doesn't solve my problem.
An extra table is not what I need in my datamodel. I need to integrate the project name in the second table. The intervalmatch just creates a table where I match the date (which can occure multiple times for multiple customers) and I can't match the correct startdate with the correct project.
Is there a way to do integrate the tabels?
Here, try this:
"Costumer name" as [Customer name],
(html, codepage is 1252, embedded labels, table is @1);
(html, codepage is 1252, embedded labels, table is @2);
Left Join (Table)
IntervalMatch(Date, [Customer name])
LOAD [Startdate project],
The concept was
Community_206822.qvf 176.0 K