topic Re: Difference between Internal Table View & Source Table View in QlikView

Difference between Internal Table View & Source Table View

Fri, 18 Oct 2013 06:19:57 GMT

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

Re: Difference between Internal Table View & Source Table View

MayilVahanan — Fri, 18 Oct 2013 06:26:07 GMT

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:

Re: Difference between Internal Table View & Source Table View

sbaldwin — Fri, 18 Oct 2013 06:28:49 GMT

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

Re: Difference between Internal Table View & Source Table View

Fri, 18 Oct 2013 07:46:37 GMT

Thanks for your replies Steve & Mayil

Re: Difference between Internal Table View & Source Table View

Wed, 27 May 2015 05:00:05 GMT

Nice and thank you