Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Link table with different common columns

Hi There

I am creating data model using Link table method, I have few tables with common columns them.

I am creating composite key to join these tables for using Link table.

Is it possible to create composite key using different columns combinations?

Please find attached qvf file for your reference.

3 Replies
ashishpalkar
Contributor II

Re: Link table with different common columns

App

dcj
Valued Contributor II

Re: Link table with different common columns

Yes, it´s possible if you have the same columns on each table.

You could use diferent names on each field in order to do diferent metrics.

But, be carefull with this data model, because sometime one field could have diferent data and the connection won´t work correctly.

ashishpalkar
Contributor II

Re: Link table with different common columns

Thanks Ricardo , can you suggest any changes required for the attached app?