Discussion board where members can get started with QlikView.
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.
you have to read the qvd
change the column (as below, or with applymap)
store the qvd
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