Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

robert2012
New Contributor III

Change values in the load

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!

1 Solution

Accepted Solutions
Not applicable

Re: Change values in the load

try to use

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

5 Replies
fdelacal
Valued Contributor

Re: Change values in the load

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.

MVP
MVP

Re: Change values in the load

try something like this:

map1:

mapping load * inline [

x, y

M, Munich

FFM, Frankfurt

] ;

TabelName:

Load

          ApplyMap('map1' , Town) as MappedTown

From ....;

Not applicable

Re: Change values in the load

try to use

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

Not applicable

Re: Change values in the load

TRY THIS

maptable:

mapping load * inline [

X, Y

M, Munich

FFM, Frankfurt

] ;

MAP Town using  maptable;

load * inline [

Town

M

FFM

] ;

Re: Change values in the load

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

Community Browser