Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
http://easyqlik.com/download.html
Hope that helps.
try something like this:
map1:
mapping load * inline [
x, y
M, Munich
FFM, Frankfurt
] ;
TabelName:
Load
ApplyMap('map1' , Town) as MappedTown
From ....;
try to use
pick(match(Town,'M','FFM'),'Munich','Frankfurt') AS TOWN_NEW
TRY THIS
maptable:
mapping load * inline [
X, Y
M, Munich
FFM, Frankfurt
] ;
MAP Town using maptable;
load * inline [
Town
M
FFM
] ;
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