Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
At what context we use these joins,mapping and link table?i am bit confusing when to use ,why to use ?
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.
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
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.