topic Append and Replace in QlikView

Append and Replace

Mon, 28 Jan 2013 21:15:22 GMT

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

Re: Append and Replace

Oleg_Troyansky — Mon, 28 Jan 2013 23:35:40 GMT

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

Re: Append and Replace

Tue, 29 Jan 2013 14:17:41 GMT

Thankyou......I dont have any date fields in the excel file. How can I filter QVD without any date fields?