Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sgg_gaikwad
Partner - Contributor II
Partner - Contributor II

How to create a Link table in qlikview

Please explain with One Simple Example

4 Replies
jsingh71
Partner - Specialist
Partner - Specialist

Please follow below link

What is Link Tables? What is the use?

--Jai

sgg_gaikwad
Partner - Contributor II
Partner - Contributor II
Author

Hi Jai,

Thanks for your Response           

jagan
Luminary Alumni
Luminary Alumni

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
Not applicable

Hi,

Attached document may help you.