topic Re: IntervalMatch with two fields multiplying records in QlikView

IntervalMatch with two fields multiplying records

mtucholski — Sat, 16 Nov 2024 19:57:24 GMT

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 — Sat, 05 Oct 2019 03:07:26 GMT

Try inner join before intervalmatch statement.

venkat1 — Sat, 05 Oct 2019 05:08:18 GMT