i met an problem i would like to implement an incremental extract based on id i loaded before in the Extract script…
In fact, I’ve two table an Order Line and Order Header which are rely on an ID_Order_header.
For the Order Header, there is no problem cause I ve an field Date_Order so I can extract only the data of the day or the month anywhere…. But for the line, I don’t have a Date_Order to implement an incremental so I would like to extract the data of my line Order only for the ID_Order_header I ve extracted before..
Re: Incremental Extract on an database based on Id
The join in the SQL statement is executed on the database server and will use almost certainly use an index. So that join should not be very costly. If it is you need to put your database administrator to work.
But yes, you can do it differently by loading all the records from the OrderLine table into Qlikview and then remove the ones you don't need with a left keep.
SQL Select * From OrderHeader Where Date_Order > ...somevalue...;