topic Re: Interval Match in QlikView

Interval Match & Incremental Load

Tue, 23 Oct 2012 18:37:52 GMT

Hi All,

What is interval match and how it is used. Can some one explain with any example also.

Thanks

Re: Interval Match

MayilVahanan — Tue, 23 Oct 2012 18:48:20 GMT

From help:

The IntervalMatch prefix to a Load or Select (SQL) statement is used for linking discrete numeric values to one or more numeric intervals.

intervalmatch (field)(loadstatement | selectstatement )

matchfield is the field containing the discrete numeric values to be linked to intervals.

loadstatement or selectstatement must result in a two-column table, where the first field contains the lower limit of each interval and the second field contains the upper limit of each interval. The intervals are always closed, i.e. the end points are included in the interval. Non-numeric limits render the interval to be disregarded (undefined) while NULL limits extend the interval indefinitely

I think following attached file help to understand the concept..

Re: Interval Match

Tue, 23 Oct 2012 19:01:57 GMT

Hi,

Thanks, But if i have table like

EmpId	Ename	Desc	DeptID	DesicID
1	A1	dsds	1	DE1
2	A2	dsds	2	DE3
3	A3	dsdgfg	3	DE4
4	A4	gfgf	3	DE5
5	A5	fg	4	DE8

and i load this five rows in Qlikview application and after this five rows one row added like

DE2

but this time i want to load only this 6 row with the help of interval match how i can achieve this.

Please reply it urgently.

Thanks

Re: Interval Match

MayilVahanan — Tue, 23 Oct 2012 19:13:16 GMT

I didn't get your requirement, first please check the interval match concept usage..As per your requirement, interval match can;t be used..

Please give a brief description about your requirement..

Re: Interval Match

robert99 — Tue, 23 Oct 2012 19:15:24 GMT

Why do you want to use interval match (it does not seem to be appropriate)

Re: Interval Match

Tue, 23 Oct 2012 19:21:58 GMT

Hi,

As i describe in a table there is 5 rows which is all ready loaded on to the qlikview application, then the 6 row as i mention which is added on the table. Then i again load this table on the Qlikview application but this time there is 6 rows is added on the table so i does not want to load the previousley loaded 5 rows because they are all ready loaded on the qlikview application.

So with the concept of the Interval Match i want to load only 6 row because it is newly added like wise suppose there is 1000 rows but newly added is 15 rows so total rows are 1015 but i want to load only newly added 15 rows how i can do this with the help of Interval match.

Thanks & Regards

Re: Interval Match

robert99 — Tue, 23 Oct 2012 19:38:03 GMT

I don't believe you can do this using intervalmatch

If you just want to load the additional records (not the whole table again although for a small file this is best). Then refer to the manual under

25.7 using QVD files for incremental load

Re: Interval Match

Tue, 23 Oct 2012 19:43:59 GMT

Hi,

Sorry you are right i want to do this with Incremental load. Can you explain it i know that it can be done with Incremental load.

Thanks & Regards

Re: Interval Match

MayilVahanan — Tue, 23 Oct 2012 19:47:03 GMT

Interval match concept is not suit here.. Please use incremental Load