Discussion Board for collaboration on QlikView Scripting.
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!
Go to Solution.
try to use
pick(match(Town,'M','FFM'),'Munich','Frankfurt') AS TOWN_NEW
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
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