How to map a Two tables?

[#1]

Hi team

I Have two tables

A, B tables

A:

Country

Usa

India

lao

B:

Country

United state of america

India(alternate)

lao

Now how to map B Table with A table

Require out put:

Country

Usa

India

lao

[#2]

A:

LOAD

Country,

rowno() as key

from tableA;

B:

load Country as country_name ,

rowno() as key

from tableB;

[#3]

its not giving require out put

[rphpacheco]

How are coming your data?

Comes from the database?

It is in line?

Or a file?

[#5]

From first table from mysql db

second table from excel

[#6]

Hi,

You can create a mapping table :

Map_Country:

MAPPING LOAD * INLINE [

Country_name, Country

'United state of america', 'Usa'

'India(alternate)', 'India'

'lao', 'Iao' ];

Then when you load your table B (from Excel), use this formula to load the country :

ApplyMap('Map_Country', Country) as Country

[#7]

iam getting  erro Country filed not found

[#8]

You have to use the name of the field as define in your excel file in the applymap statement

[#9]

try this , here i'm providing two concepts of mapping--

table1:

load * from table1;

table2:

load * from table2;

Map1:

MAPPING LOAD  Country,

                           CountryName

Resident table1;

Mappedtable:

Load Country, ApplyMap('Map1', Country) as CountryName

resident table2;

**********************************************************************************

You can also mapped according to this code.

load * from table1;

load * from table2;

CountryMapName:

Mapping load County, countryName

Resident table1;

Map Country USING CountryMapName;

Data:

load Country

resident table2;

[#10]

hmm