Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ts3st1000
New Contributor

Link Table

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.

3 Replies
zebhashmi
Valued Contributor

Re: Link Table

Digvijay_Singh
Honored Contributor III

Re: Link Table

I suggest go for this book -

Book: QlikView for Developers

Ivan_Bozov
Valued Contributor

Re: Link Table

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 ...