topic Re: Multiple condition matching in App Development

Multiple condition matching

wood — Thu, 27 May 2021 11:29:13 GMT

hello everybody,

How to easily implement the following scenario in the script editor:
T2. Logic_year needs to be matched from t1,

Matching conditions:
T2. Name = t1.name and t2. Date <=t1.end_date and t2. Date >=t1.start_date

t1:

t2:

thanks

GaryGiles — Thu, 27 May 2021 11:49:30 GMT

You need to use the IntervalMatch() function. After loading the 2 tables add this:

inner Join IntervalMatch (DATE, name, logic_year)
Load start_date, end_date, name, logic_year
Resident t1;

wood — Fri, 28 May 2021 03:23:41 GMT

thank you very much!