topic Re: Update values in QVD file in QlikView

Update values in QVD file

Fri, 27 Mar 2015 11:18:05 GMT

I have a table in QVD file with the following structure like:

i's all about using a different split for countries. I'd like to update column without changing the rest of my table. So results should be like:

I do have a separate file I can link with, but I need this change to be done in the original file.

Your help will be highly appreciated.

Pierre

maxgro — Fri, 27 Mar 2015 12:47:21 GMT

you have to read the qvd

change the column (as below, or with applymap)

store the qvd

load

[Header 1],

[Header 2],

pick(match([Header 2], 'BE','NL','LU','FR','CH','IT'), 'X','Y','Y','Z','Z','Z',) as [Header 3]

from a.qvd (qvd);

store a into a.qvd (qvd);