topic Replace only some lines in QlikView

Replace only some lines

Thu, 25 Jul 2013 12:20:38 GMT

Hello,

I woul like to know how to do to replace some rows in a table of my Qlikmart.

For example I charge in using partial load every day the data of the day in my fact table “tickets”.

The problem is that I would like to know if it s possible to replace the lines of precedent day without deleting all the old data in using REPLACE and id_day.

My table has theses field :

Fact_tickets :

ID_day , Id_tickets , indicator1, indicator2,etc…

How is working "Replace" cause i ve read that it s working only with table.... and you can t choose the line you replaced only the table...?

Thanks for you help

Pierre

Re: Replace only some lines

ariel_klien — Thu, 25 Jul 2013 12:29:16 GMT

Take a look here:

http://www.learnqlickview.com/incremental-data-load-in-qlikview/

Ariel

Re: Replace only some lines

Thu, 01 Aug 2013 08:51:23 GMT

Hello Ariel,

thanks for your link...

But i think it doesn't respond to my problem cause in the exemple the application reload all the lines everytime he wants to change or update some lines.

In my case, i ve too many lines to load... i can't load all the lines i need in my application (it takes some days...) that the reason why i want to use the "partial reload" .

Every day i want to load in my qlikmart only the lines of the day....

But how can i do if i want to change or to update the lines of an old day without reloading all the lines of all the days...

Thanks Pierre

Re: Replace only some lines

tresB — Thu, 01 Aug 2013 09:09:25 GMT

Hello Pierre,

Incremental load does not load all lines, it just check all records before load and that is obvious when you need to change/update the lines of an old day and the same can't be achieved with partial load, because that's a kind of concatenation even without checking the duplication or update/change in the preloaded data.

hope this helps.