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