Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is interval match.Please give an example.
Thanks in advance
Hi Check this also.
// ==== Load Activities ==================================================
Data:
LOAD * INLINE [Date, Key, Desc
2010-01-01, A, z1v
2010-02-01, A, a1v
2010-03-01, A, z1v
2010-04-01, A, b1v
2010-05-01, A, d1v
2010-06-01, A, e1v
2010-01-01, B, f1v
2010-02-01, B, t1v
2010-03-01, B, k1v
2010-04-01, B, e1v
2010-05-01, B, z1v
2010-06-01, B, a1v];
// ===== Load the Contract ================================================
Contract:
LOAD * INLINE [START_DATE, END_DATE, Key, Value
2010-01-01, 2010-12-31, A, 5
2010-01-01, 2010-03-30, B, 3
2010-04-01, 2010-12-31, B, 4];
// ==== Link Fields from Data with Contract into the Contract-Table ========
INNER JOIN INTERVALMATCH (Date, Key) LOAD START_DATE, END_DATE, Key RESIDENT Contract;
// ==== Join into one Table only, remove contract-Data =====================
JOIN (Data) LOAD * RESIDENT Contract;
DROP TABLE Contract;
DROP FIELD START_DATE, END_DATE;
Check here
Also, read here
The Interval Match is one of the functions in QlikView that can be used to match a numeric value in a single table, such as date, timestamp, score, percent or any number, to an interval or duration in a second table. The IntervalMatch function discreet data to one or more dimensions that are changing over time. It can be us for resolving slowly changeing dimensions by linking the specific key fields to the appropriate numeric intervals. It can be used with LOAD, Inline and SQL select statements.
Check these:
https://www.c-sharpcorner.com/UploadFile/35fef0/intervalmatch-function-in-qlikview/
Example:
EventLog:
LOAD * Inline [
Time, Event, Comment
00:00, 0, Start of shift 1
01:18, 1, Line stop
02:23, 2, Line restart 50%
04:15, 3, Line speed 100%
08:00, 4, Start of shift 2
11:43, 5, End of production
];
OrderLog:
LOAD * INLINE [
Start, End, Order
01:00, 03:35, A
02:30, 07:58, B
03:04, 10:27, C
07:23, 11:43, D
];
//Link the field Time to the time intervals defined by the fields Start and End.
Inner Join IntervalMatch ( Time )
LOAD Start, End
Resident OrderLog;
Hi Check this also.
// ==== Load Activities ==================================================
Data:
LOAD * INLINE [Date, Key, Desc
2010-01-01, A, z1v
2010-02-01, A, a1v
2010-03-01, A, z1v
2010-04-01, A, b1v
2010-05-01, A, d1v
2010-06-01, A, e1v
2010-01-01, B, f1v
2010-02-01, B, t1v
2010-03-01, B, k1v
2010-04-01, B, e1v
2010-05-01, B, z1v
2010-06-01, B, a1v];
// ===== Load the Contract ================================================
Contract:
LOAD * INLINE [START_DATE, END_DATE, Key, Value
2010-01-01, 2010-12-31, A, 5
2010-01-01, 2010-03-30, B, 3
2010-04-01, 2010-12-31, B, 4];
// ==== Link Fields from Data with Contract into the Contract-Table ========
INNER JOIN INTERVALMATCH (Date, Key) LOAD START_DATE, END_DATE, Key RESIDENT Contract;
// ==== Join into one Table only, remove contract-Data =====================
JOIN (Data) LOAD * RESIDENT Contract;
DROP TABLE Contract;
DROP FIELD START_DATE, END_DATE;