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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ts3st1000
Contributor
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
Digvijay_Singh

I suggest go for this book -

Book: QlikView for Developers

Ivan_Bozov
Luminary
Luminary

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

vizmind.eu