Problem While Joining Two Tables

[#1]

Hello

I have a Problem while joining two tables , table1 and table2 having two different column names(Emp_ID and E_Id) but same data.

Table1:

Emp_ID     Emp_Name     Dept_No

Table2:

E_Id     C_Address

Can any one help how to join these two tables.

[jonathandienst · Accepted solution]

Hi

Alias the names to the same name. Like this:

Table1:

LOAD Emp_ID,

     ...;

Join (Table1)

LOAD E_Id As Emp_ID,

     ...'

HTH

Jonathan

[#3]

Hi Kalyan,

You have rename your field name by using aliases .the below clear your doubt...

Try like this ---

Load

EMP_ID  As Key

Emp_Name

Dept_No

from path

inner join (diffrent types of join you can use here..)

Load

E_id  As Key
C_Address

from path

Hope this will help you !!!!!

Regrads

Sarfaraz Sheikh

[ashfaq_haseeb]

Hi,

Try this

load

Emp_ID,

Emp_Name,

Dept_No;

from Table1;

left join

load

E_Id as Emp_ID,

C_Address;

from Table2;

Regards

ASHFAQ

[#5]

hi kalyan

this is easy. first, you change the field name E-Id as Emp_ID then, join the two tables as

load *

from table1_path

join

load * from table2_path

cheers,
kunal bhattacharjee

[its_anandrjs]

Hi,

When joining two table they need exactly same field names then rename that fields and write like

Table1:

Load 

Emp_ID,Emp_Name,  Dept_No

From Location;

Left Join

Table2:

Load

E_Id as Emp_ID, C_Address

From Location;

Regards

Anand