Join two table by interval dates and two fields

[lomi89]

Hello,

I would like to join two table by an interval dates and two fields. I don't know how I could do it because I saw the function intervalmatch but I need join another fields:

TABLE_CLIENT :
LOAD
DATE_EX,
CLIENT,
CONTRAT
RESIDENT TEMP;

TABLE_DATE:
LOAD
DATE_FIRST,
DATE_END,
CLIENT,
CONTRAT
RESIDENT TEMP;

Thank you very much.

[MarcoWedel · Accepted solution]

IntervalMatch(DATE_EX,CLIENT,CONTRAT)

see also

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...