I load several csv.-files and store them into one qvd.
Now I have the problem that there is one row (Town), which has many times two wrong values.
I want to change them like:
Is this in the load possible?
Thank you for helping!
You can use qcViewer.
you cna change data and name fields.
This is the website to free download.
Hope that helps.
try something like this:
mapping load * inline [
ApplyMap('map1' , Town) as MappedTown
try to use
pick(match(Town,'M','FFM'),'Munich','Frankfurt') AS TOWN_NEW
MAP Town using maptable;
load * inline [
Try like this
Load If(match(Town,'M','FFM'), Pick(match(Town,'M','FFM'),'Munich','Frankfurt'), Town) as Town;
Load * Inline
hope that helps
Retrieving data ...