topic Re: No Modified Time on DB Table in QlikView

No Modified Time on DB Table

william_denholm — Mon, 20 Apr 2015 08:15:24 GMT

Hello,

We have a table where we are looking to implement an incremental load in to QV.

Problem I have is that the table does not contain any modified time etc. However, there is a table with some of the same data that does have a modified time. When this table is updated, the other table is also updated.

Example:

Table 1 - Order

Order Number, modified time, destination, etc

Table 2 - Order Details

Order Number, Line no, Part No.

Order Number is the same on both but there are multiple entries for each order (as each order has more than one line)

How can I query Table 2 to perform an incremental load?

Re: No Modified Time on DB Table

Anonymous — Mon, 20 Apr 2015 08:29:22 GMT

Hi William,

Instead of looking for Modified Date Time field, go with Primary Key in both tables

For Ex:Get the PK at WHERE and use the exists function to match your record's availability.

-Jay

Re: No Modified Time on DB Table

marcus_malinow — Mon, 20 Apr 2015 08:33:01 GMT

The easiest way would be to join Table 1 and Table 2 in your initial SQL query

e.g.

select

Table 1.Order Number,

Table 1.modified time,

Table 2.Line no,

Table 2.Part No

FROM Table 1

INNER JOIN Table 2 on Table 2.Order Number = Table 1.Order Number

WHERE Table 1.modified time > '[Modified Time Variable]'

Re: No Modified Time on DB Table

william_denholm — Mon, 20 Apr 2015 09:10:02 GMT

Thank you, this worked perfectly!