Editing a QVD file on load

[Anonymous]

HI All

I use a QVD file to store all my data.  I regularly add to the QVD file as new data is available then reload into Qlik

I would like to swap and replace specific data for a specific field within my QVD.  I know I could simply reload the data into the QVD and replace the old, but I'm guessing there is a way to replace specific existing data when loading the QVD data itself.

I was thinking when loading the QVD into Qlik of using the "IF(Fieldname='ABC','XYZ') as Fieldname" statement, but as you know that wont work as Qlik thinks you are adding a new fieldname.  I dont want to create a new Fieldname.

Is there a way to use the IF statement or something else?

Thanks

[felipedl]

Hi Mark,

Attached an example with some random data.

What I did was basically what you described.

1. Load the data from the file

2. Save the table to QVD

3. Drop table.

4. Load another table from the QVD and using some condition.

5. Store the table in the same QVD.

Hope it helps.

Regards,

Felipe.

[Anonymous]

Hi Felip - I cant open your example

[felipedl · Accepted solution]

Attaching separate files.

[Anonymous]

thats what I was thinking but didnt know how to write.  Thanks!