Change values in the load

[Anonymous]

Hi all,

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.

Town:

M

FFM

I want to change them like:

Town:

Munich

Frankfurt

Is this in the load possible?

Thank you for helping!

[fdelacal]

You can use qcViewer.

you cna change data and name fields.

This is the website to free download.

http://easyqlik.com/download.html

Hope that helps.

[tresesco]

try something like this:

map1:

mapping load * inline [

x, y

M, Munich

FFM, Frankfurt

] ;

TabelName:

Load

          ApplyMap('map1' , Town) as MappedTown

From ....;

[#4 · Accepted solution]

try to use

pick(match(Town,'M','FFM'),'Munich','Frankfurt') AS TOWN_NEW

[#5]

TRY THIS

maptable:

mapping load * inline [

X, Y

M, Munich

FFM, Frankfurt

] ;

MAP Town using  maptable;

load * inline [

Town

M

FFM

] ;

[MayilVahanan]

Hi

Try like this

Load  If(match(Town,'M','FFM'), Pick(match(Town,'M','FFM'),'Munich','Frankfurt'), Town) as Town;

Load * Inline

[

Town

M,

FFM,

Others

];

hope that helps