Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

upaliwije
Contributor II

Data loadin

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

2 Replies

Re: Data loadin

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 onSmiley Very HappyimA-ID

  • DimA-ID
  • DimA-Text

And Table DimA will join onSmiley Very HappyimB-ID

  • DimB-ID
  • DimB-Text

Best Regards,     Bill

.

Not applicable

Re: Data loadin

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.

Community Browser