topic Re: Link table in QlikView

Link table

Nagaraju_KCS — Tue, 17 Dec 2013 06:16:02 GMT

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);

Re: Link table

vikasmahajan — Tue, 17 Dec 2013 06:20:11 GMT

PFA example of link table hope this helps you.

Vikas

Re: Link table

jagan — Tue, 17 Dec 2013 06:20:49 GMT

Hi,

What is the key column between this two tables?

Regards,

Jagan.

Re: Link table

Tue, 17 Dec 2013 06:46:29 GMT

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!