Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);