Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Update values in QVD file

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

Header 1Header 2Header 3
1BEA
2NLA
3LUA
4FRB
5CHB
6ITC

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 1Header 2Header 3
1BEX
2NLY
3LUY
4FRZ
5CHZ
6ITZ

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

View solution in original post

1 Reply
Highlighted
MVP
MVP

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

View solution in original post