mapping

[n1ef5ng1]

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

[amars]

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..    

[n1ef5ng1]

i can't. it says Date not found. is it because my date is on the another table call calendar?

[amars]

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...

[er_mohit]

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

];