Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

8 Replies
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
robert99
Specialist III
Specialist III

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

Not applicable
Author

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
Specialist III
Specialist III

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
Author

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

MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.