topic Re: joins ,mapping,link table? in QlikView

joins ,mapping,link table?

sbkumar — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: joins ,mapping,link table?

jonathandienst — Fri, 09 Mar 2018 06:57:03 GMT

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

Re: joins ,mapping,link table?

imrasyed — Fri, 09 Mar 2018 07:04:19 GMT

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

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.