Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 excel files for 2 months(jan,feb), I am loading Jan excel file and storing into qvd.(QVW-1)
Now I want to load feb and append it with jan. As the field names are same I am loading Feb excel file and appending it to jan QVD and storing them to QVD again.(QVW-2)
if the feb excel file data is changed and I am loading it again and appending to QVD generated from QVW-2, I ll get 3 rows jan,feb and changed feb data...........
Is there any way How can I get only 2 rows where new data shold be replaced by old data.....Thanks
your logic should account for the possibility of the duplication. If February can appear twice in your environment, then you shoud implement conditional load, for example:
- load the data from the source (Excel).
- Load the data from QVD, with the WHERE clause, filtering dates (months) that are less than the previously loaded from Excel.
This way, Feb data coming from QVD, can be suppressed
Thankyou......I dont have any date fields in the excel file. How can I filter QVD without any date fields?