Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Data loadin

How can I link more than one  dimension fields to a fact table at the time of loading data

2 Replies
Anonymous
Not applicable

Upali

Any identical [case sensitive] field names in different tables will result in a link.

So if your Fact Table is say:

  • DimA-ID
  • DimB-ID
  • Fact-Value

Then Table DimA will join on:DimA-ID

  • DimA-ID
  • DimA-Text

And Table DimA will join on:DimB-ID

  • DimB-ID
  • DimB-Text

Best Regards,     Bill

.

Not applicable

Hi,

Keep also in mind that in QV you can link 2 tables with 1 field only.

However, this key field can be a combination of several fields. For example:

Scenario1: invoice detail linked through InvoiceNo to invoice header

InvoiceHeader:

Load InvoiceNo,

Customer,

etc...

InvoiceDetails:

Load InvoiceNo,

LineNo,

Item,

etc...

Scenario2: company, transaction type and transaction number constitute the key

TransactionHeader:

Load Company,

TrxType,

TrxNo,

Company & ' | ' & TrxType & ' | ' & TrxNo as TrxKey,

Customer,

etc...

TransactionDetails:

Load Company & ' | ' & TrxType & ' | ' & TrxNo as TrxKey,

ItemNo,

Qty,

Amount,

etc...

After validating your links, you can consider using the autonumber function to store the key field as a number instead of string (for performance):

AutoNumber(Company & ' | ' & TrxType & ' | ' & TrxNo, 'TrxCounter') as TrxKey.

Hope this helps you.