Tutorials & Examples Web-help Blog

Rules on 2 or more tables


#1

Hi,

Sorry if my question was already asked here in the community, but I didn’t find the solution I needed
.
Is there a way to apply rules on 2 or more pages?

I have 2 tables. Say
ClaimTable: Claim ID, Name, Job, Due Date, Date Paid.
Job Table: Job ID, Name, Job, Job Start, Job End

I need to link the claim with the job where Name=Name and Job = Job and Job Start<DueDate<Job End + 3 months.

I can do it with Rule action but not sure how to apply rules on 2 tables.

Any help would be much appreciated.

Regards,
AK


#2

The “Interval merge” action does exactly that kind of merging.

See the example below:

interval-merge.morph (3.8 KB)
Book1.xlsx (9.2 KB)