topic Re: incremental load in QlikView

incremental load

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

in incremental load data is updated only once per a month but due to data base connection error data is loaded 50% only how can i load remaining without adding duplicates

Re: incremental load

shiveshsingh — Fri, 16 Feb 2018 10:01:59 GMT

You can use where not exists(FieldName) while loading data again from source. It will not load the already loaded data.

Re: incremental load

YoussefBelloum — Fri, 16 Feb 2018 10:02:13 GMT

Hi,

here is one method:

you can look at the date column in your table in your app and do a manual incremental load on it by adding the rows of the missing dates one day before the next Incremental scheduled reload.

Re: incremental load

manoj217 — Mon, 19 Feb 2018 07:25:21 GMT

but i want to load only unloaded data without reloading the application with previous time stamp.

in your suggestion application starts from first step and those previously loaded 50% can be removed by where condition but i want to load only unloaded data

Re: incremental load

avinashelite — Mon, 19 Feb 2018 07:34:42 GMT

do you have any updated/last modified time stamp ?? if you have then you could continue the load with the last record loaded with the time stamp and then load data greater than that