Update values in QVD file

[#1]

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

Header 1	Header 2	Header 3
1	BE	A
2	NL	A
3	LU	A
4	FR	B
5	CH	B
6	IT	C

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:

Header 1	Header 2	Header 3
1	BE	X
2	NL	Y
3	LU	Y
4	FR	Z
5	CH	Z
6	IT	Z

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 · Accepted solution]

you have to read the qvd

change the column (as below, or with applymap)

store the qvd

a:

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);