Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try inner join before intervalmatch statement.
Try inner join before intervalmatch statement.