topic mapping in QlikView

mapping

n1ef5ng1 — Tue, 10 Sep 2013 02:11:12 GMT

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

Re: mapping

amars — Tue, 10 Sep 2013 02:18:44 GMT

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

Re: mapping

n1ef5ng1 — Tue, 10 Sep 2013 03:49:04 GMT

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

Re: mapping

amars — Tue, 10 Sep 2013 04:07:25 GMT

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

Re: mapping

er_mohit — Tue, 10 Sep 2013 04:22:49 GMT

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

];