Link Table

[ts3st1000]

Hi, I am trying to get rid of synthetic key and thinking to use a linktable. considering i am very new to all this, can you please suggest a good reference and steps to follow please.

Thanks very much.

[zebhashmi]

link table creation between facts

Implementation of Link Tables

[Digvijay_Singh]

I suggest go for this book -

Book: QlikView for Developers

[Ivan_Bozov]

Hi! Have you considered creating a key field?

Table1:
LOAD
     Field_A,
     Field_B,
     Field_C,
     Field_D,
     Field_A & '-' & Field_B AS Key
FROM ...

Table2:
LOAD
//   Field_A,
//   Field_B,
     Field_E,
     Field_F,
     Field_A & '-' & Field_B AS Key
FROM ...