Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i am trying to do a data cleaning on the database by mapping
i would want to fulfill two fields to introduce a new fields namely
Date, City and New_City
My database contain fields such as
Dec 12 , Indosisne
Dec 12, Enlgna
Jan 13, Fancer
I would want it to fulfill two fields, Dec 12, Indosisne to Indonesia(New_City)
Dec 12 and Enlgna to England(New_City)
Jan 13, Fancer to France (New_City)
anybody know how to do it.
thanks
Hi Benn,
You can put a mapping like below
CityMap:
Mapping
Load Distinct
(Date & City) As DateCity,
NewCity
From Table.QVD(qvd);
Load
Date,
City,
ApplyMap('CityMap', Date&City) As NewCity
From Table.QVD(qvd);
Thanks..
i can't. it says Date not found. is it because my date is on the another table call calendar?
Can you share a sample application?
Otherwise just for mapping you can join load thease two tables like
Table1:
Load *,
LinkKey
from Table1.Qvd(QVD);
Join (Table1)
Load *,
LinkKey
from Table2.Qvd(QVD);
CityMap:
Mapping
Distinct
(Date & City) As DateCity,
NewCity
From Table.QVD(qvd);
Drop Table Table1;
Thanks...
Try this
Tab:
Mapping LOAD * Inline [
Date,City
Dec 12 , Indosisne
Dec 12, Enlgna
Jan 13, Fancer
];
MAP Test using Tab;
LOAD * Inline [
New_City
Indonesia
England
France
];