topic Re: Editing a QVD file on load in QlikView

Editing a QVD file on load

Anonymous — Wed, 31 May 2017 16:54:55 GMT

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

Re: Editing a QVD file on load

felipedl — Wed, 31 May 2017 17:20:33 GMT

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.

Re: Editing a QVD file on load

Anonymous — Wed, 31 May 2017 17:30:55 GMT

Hi Felip - I cant open your example

Re: Editing a QVD file on load

felipedl — Wed, 31 May 2017 17:34:04 GMT

Attaching separate files.

Re: Editing a QVD file on load

Anonymous — Wed, 31 May 2017 17:38:50 GMT

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