How-To Link together to QVDs.

[BrianDH]

Team I have two QVD files with matching keys.  How can I link them so as to access fields from one to the other? 

[treysmithdev · Accepted solution]

You can load both QVDs and link them in a data model by naming a field the same, which links the two internal tables.

For example:

Sales:
Load
    InvoiceId&'|'&ProductId as %SalesKey // Links to Discount
    InvoiceId,
    ProductId as %ProductId, // Links to Product
    Date,
    Qty,
    Amount
From
    [lib://QVD/Sales.qvd];

Discount:
Load
    InvoiceId&'|'&ProductId as %SalesKey // Links to Sales
    DiscountDesc,
    DiscountPercentage
From
    [lib://QVD/Discount.qvd];

Product:
Load
    %ProductId, // Links to Sales Table
    ProductId,
    ProductName,
    ProductCode,
    ProductCategory
From
    [lib://QVD/Product.qvd];

[BrianDH]

TY