Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Interval Match & Incremental Load

Hi All,

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

Thanks

1 Solution

Accepted Solutions

Re: Interval Match

HI

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

8 Replies

Re: Interval Match

HI

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..

Not applicable

Re: Interval Match

Hi,

Thanks, But if i have table like

EmpIdEnameDescDeptIDDesicID
1A1dsds1DE1
2A2dsds2DE3
3A3dsdgfg3DE4
4A4gfgf3DE5
5A5fg4DE8

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

6 A6fg1DE2

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

Hi

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..

robert99
Valued Contributor II

Re: Interval Match

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

Not applicable

Re: Interval Match

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

robert99
Valued Contributor II

Re: Interval Match

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

Not applicable

Re: Interval Match

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

HI

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

Community Browser