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: 
qv_testing
Specialist II
Specialist II

Link table

Hi Community,

How to create linktable..

Sales:

LOAD [SalesTrans ID],
CountryCode,
ProductId,
SumOfSales,
Date
FROM
..\Linktable.xlsx
(
ooxml, embedded labels, table is Sheet1);

Purchases:
LOAD [PurcTrans ID],
CountryCode,
ProductId,
Date,
[OrderQty]
FROM
..\Linktable.xlsx
(
ooxml, embedded labels, table is Sheet2);

3 Replies
vikasmahajan

PFA example of link table hope this helps you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
jagan
Luminary Alumni
Luminary Alumni

Hi,

What is the key column between this two tables?

Regards,

Jagan.

Not applicable

Hi

The Trick is with Qualify and Unqualify.

Unqualify the fields you want in the Link Table and Qualify the rest.

Make sure the Unqualify Field names are same in the tables used.

All the best!