what is difference between source table viewer and internal table viewer?

[#1]

what is difference between source table viewer and internal table viewer?

[its_anandrjs · Accepted solution]

Hi,

1. Internal view is a view and it display a view when qlikview internally link or stores the table like if there is a synthetic keys created or synthetic fields are created we are able to see that tables and keys on the internal view. Basically synthetic table is created and it is used to link the composite multiple same keys in the different table.

2. The source table view is a view where if there is a synthetic table or fields is created it will not shown but shown only link.

[maxgro]

search for table in the online help and....

from online help

There are two views available, the layouts of which are stored separately. The two views are:

• The Internal Table View is the default view. It shows the data tables as QlikView stores them. Composite synthetic keys are formed in tables that share more than one field. Synthetic tables are used to link them. This view offers the best understanding of the QlikView logic and also provides a very clean layout where each pair of tables has a maximum of one connector between them. 
• The Source Table View shows data tables as QlikView reads them. Here there are no synthetic fields or synthetic tables. Composite keys are represented by multiple connectors between tables. 

[MK_QSL]

Source : QlikView 11 For Developers

The table viewer shows the tables (boxes) and their associations (connectors). When more than two tables are associated via the same key, it will be indicated with a small blue dot in the connector line.

Internal Table View is the default option and shows how the data is stored in QlikView. If synthetic keys are created, they are shown in this view.

However, Source Table View shows how QlikView reads the data, and when synthetic keys are present in the model they are not shown in this view. Instead, multiple connectors between tables are displayed.