How to link Table.

[renuka_sasikumar]

Hi,

I have 4 table.

Table A	Table B	Table C	Table D
VerticalCode	HRPosition	EmpID	HRPosition
SubVerticalCode	EmpID	SubVerticalCode
VerticalName	VerticalCode
SubVerticalName	SubVerticalCode

Now I m doing

Table B

Left Keep

Table C

Right Keep

Table D

I want Table A data i.e. VerticalName & SubVerticalName.

Thanks & Regards,

Renuka

Cananyone plz help me

[#2]

Try:

Table A:

LOAD

    VerticalCode

    SubVerticalCode

    VerticalName

    SubVerticalName

From <data table A origin>;

Left Join(Table A)

LOAD

    HRPosition

    EmpID

    VerticalCode

    SubVerticalCode

From <data table B origin>;

Left Join(Table A)

LOAD

    EmpID

    SubVerticalCode

From <data table C origin>;

Table D

LOAD

    HRPosition

From <data table D origin>;

Table should have:

VerticalCode

SubVerticalCode

VerticalName

SubVerticalName

EmpID

HRPosition

[xavieravinson]

Based on emp id join the table B and C.

concatenate table d.

now you have two tables and provide link......................................

[renuka_sasikumar]

Hi,

I tried using Join, but i get problem in Data.

I wanna do it wid Keep only.

Thanks & Regards,

Renuka.

[SunilChauhan]

Table B

left join

Table A

left join

Table c

left join

table c