Link table

[Nagaraju_KCS]

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

[vikasmahajan]

PFA example of link table hope this helps you.

Vikas

[jagan]

Hi,

What is the key column between this two tables?

Regards,

Jagan.

[#4]

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!