topic Re: How to link Table. in QlikView

How to link Table.

renuka_sasikumar — Fri, 26 Sep 2014 09:57:13 GMT

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

Re: How to link Table.

Fri, 26 Sep 2014 10:05:31 GMT

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

Re: How to link Table.

xavieravinson — Fri, 26 Sep 2014 10:21:47 GMT

Based on emp id join the table B and C.

concatenate table d.

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

Re: How to link Table.

renuka_sasikumar — Fri, 26 Sep 2014 10:22:34 GMT

Hi,

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

I wanna do it wid Keep only.

Thanks & Regards,

Renuka.

Re: How to link Table.

SunilChauhan — Fri, 26 Sep 2014 10:41:29 GMT

Table B

left join

Table A

left join

Table c

left join

table c