Import only data match condition

[#1]

Hi there,

I have a table Sales with fields: Code, Customername, Modified (date & time), Status_code, etc.

It is a big database and I would like to make it as quickly as possible.

1) FIRST DOC -> Create QVD

First I have made a QVD with all info where Status_code >= 810 (so no orders with Work In Process)

LOAD

Code, Customername, Modified, Status_Code

now() AS Createtime_QVD;           //So I have a creatingdate of the QVD-doc

SELECT * FROM SALES;

WHERE Status_code >= 810

2) SECOND DOC -> QVW with new orders

Now I want to load all orders < 810, So I do the same but now

LOAD

Code, Customername, Modified, Status_Code;

SELECT * FROM SALES;

WHERE Status_code < 810

3) THIRD DOC -> QVW with orders which had status >=810 AND.....

Now I would like to have the orders that have become a Status_Code >=810 between the time I had run the QVD en the time I load the second doc.

But I do not now how.

I thought that I could do

WHERE Status_code >=810 AND Modified > Createtime_QVD

but I cannot link the QVD with my new QVW because I only need the Createtime_QVD and there is no link between Createtime_QVD and the data from the second doc.

At last I CONCATENATE the data to one QVW, and make my reports.

Who can help my with the third doc???

[#2]

i think in the Modified field you have only date but by using now() function you get the date + time .

so you have to apply :

date(Createtime_QVD)

so that you can use this in comparison with Modified field.

[#3]

Sorry Vijit1810 but both have date+time.

Problem is that I would like to make a QVW-doc with only the fields where Modified > Createtime_QVD.

But I can not get the field Createtime_QVD in the table Sales, because there is no link.

[kamalqlik]

You can apply Incremental load

[#5]

you can resident the table in which you created Createtime_QVD in sales table then you get the link.

hope this will solve your problem.