IntervalMatch with two fields multiplying records

[mtucholski]

Hello,

I was looking for some solution but no luck. Haven't found the case im struggling with so I decided to post it. i will apprecieate some help.

I need to connect the event with the product id. It works fine with just the timestamp, but no luck with another field key (machine).

My script is looking like that:

Events:
load
machine,
event,
time
from X
;

Order:
load
machine,
time_to,
time_from,
product_id
from Y
;

IntervalMatch:
IntervalMatch(time, machine)
load distinct
time_from,
time_to,
machine
Resident Order
;

and the output data looks like that:

It looks like this IntervalMatch is omitting the time key and is using only machine key.

[Arthur_Fong · Accepted solution]

Try inner join before intervalmatch statement.

[venkat1]

inner join.
try this link
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...