Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sbkumar
Creator
Creator

joins ,mapping,link table?

At what context we use these joins,mapping and link table?i am bit confusing when to use ,why to use ?

1 Solution

Accepted Solutions
imrasyed
Partner - Creator II
Partner - Creator II

Breifly speaking;

These are the techniques to design our DataModel for better performance,

Like removing circular loops and Synthetic Keys.

Some Qlikview Joins,Keep,Concatenation and Applymap best documents

Joins:

Join is used to merge tables based on the common key.

In qlikview the two tables are merged upon joining.

Mapping: Table A     Table B

                  F1              F1

                  F2             F3

                                   

                                   Fn

We can move field F2 to Table B using Mapping concept and the Table A will dropped automatically.

Mapping is similar to join but better than Join as per the performance.

.

Link Table:

If you have more than one common field between  tables than we can create the Link Table to remove Synthetic key formed.

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

If you are asking these sort of questions, then I suggest that you buy a Qlikview/QlikSense book or look up the online training on the Qlik Site. Or you can read these

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
imrasyed
Partner - Creator II
Partner - Creator II

Breifly speaking;

These are the techniques to design our DataModel for better performance,

Like removing circular loops and Synthetic Keys.

Some Qlikview Joins,Keep,Concatenation and Applymap best documents

Joins:

Join is used to merge tables based on the common key.

In qlikview the two tables are merged upon joining.

Mapping: Table A     Table B

                  F1              F1

                  F2             F3

                                   

                                   Fn

We can move field F2 to Table B using Mapping concept and the Table A will dropped automatically.

Mapping is similar to join but better than Join as per the performance.

.

Link Table:

If you have more than one common field between  tables than we can create the Link Table to remove Synthetic key formed.