Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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.
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.
You can apply Incremental load
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.