How to create a Link table in qlikview

[sgg_gaikwad]

Please explain with One Simple Example

[jsingh71]

Please follow below link

What is Link Tables? What is the use?

--Jai

[sgg_gaikwad]

Hi Jai,

Thanks for your Response           

[jagan]

Hi,

Try this sample script

Sales:

LOAD

A & '_' & B & '_' & C AS Key,

A,

B,

C,

Sales

FROM Table1;

LinkTable:

LOAD DISTINCT

A & '_' & B & '_' & C AS Key,

A,

B,

C,

'Sales' AS Flag

RESIDENT Sales;

DROP FIELDS A, B, C From Sales;

Budget:

LOAD

A & '_' & B & '_' & C AS Key,

A,

B,

C,

Budget

FROM Table2;

Concatenate(LinkTable)

LOAD DISTINCT

A & '_' & B & '_' & C AS Key,

A,

B,

C,

'Budget' AS Flag

RESIDENT Budget;

DROP FIELDS A, B, C From Budget;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi,

Attached document may help you.