Difference between Internal Table View & Source Table View

[#1]

Hi All,

Can anyone let me know the exact difference between Internal Table View & Source Table View,when I viewed the table structure in a qlikview document  i was not able to figure it out both of looked the same.

Any help is highly appreciated

Thanks in advance

[MayilVahanan · Accepted solution]

Hi

• 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

Source Viewer:

Internal Viewer:

[sbaldwin]

Hi, the difference for internal vs source is from how qlikview reads the data and how qlikview stores the data respectively, cause a synthetic key in your data and you will see a difference.

Thanks

Steve

[#4]

Thanks for your replies Steve & Mayil

[#5]

Nice and thank you