topic Re: Table Structure differ from in Table Viewer in QlikView

Table Structure differ from in Table Viewer

Thu, 20 Feb 2014 06:59:23 GMT

Hi All,

I have two tables like Table01 fields are A, B, C,D and Table02 fields are A, B, C.

In Internal table it shows Synthetic Key table,

But Source Table View no synthetic fields,

Could you please clarification?

Regards,

Raja.

Re: Table Structure differ from in Table Viewer

MK_QSL — Thu, 20 Feb 2014 07:11:44 GMT

QlikView Script will generate a Synthetic Key (SK) if more than one filed is common between two or more tables.

In Table View, this SK can be seen by a SK table which will holds all common key.

You can remove this SK by

1) Rename common field

2) Concatenate these two table

3) Link tables

Re: Table Structure differ from in Table Viewer

amit_saini — Thu, 20 Feb 2014 07:21:01 GMT

Hi Raja,

Please rename the common field except the main field which will help you to have better data model.

Thanks,

Re: Table Structure differ from in Table Viewer

jonathandienst — Thu, 20 Feb 2014 07:21:53 GMT

The source table view shows the keys as loaded from the sources, in your case with multi-field composite key. The other view shows the synthetic keys that QV created from the composite keys in the source view.

HTH

Jonathan

Re: Table Structure differ from in Table Viewer

Thu, 20 Feb 2014 07:22:19 GMT

Hi Manish,

Thanks for your response,

I am understand , i am waiting for Internal table View shows Synthetic Key tables but Source Table View not showing the synthetic key tables.

Regards,

raja.

Re: Table Structure differ from in Table Viewer

maxgro — Thu, 20 Feb 2014 07:24:02 GMT

from table viewer 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.

Re: Table Structure differ from in Table Viewer

Thu, 20 Feb 2014 07:26:15 GMT

Hi Jonathan,

Both tables are common fields thats what creating synthetic key(composite key) Yes well.

But Internal table View shows Synthetic Key tables but Source Table View not showing the synthetic key tables.

Regards,

raja.

Re: Table Structure differ from in Table Viewer

pandiarajan — Thu, 20 Feb 2014 08:36:49 GMT

hello raja,

Read Below link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/18/the-table-viewer

Re: Table Structure differ from in Table Viewer

Sat, 22 Feb 2014 14:37:06 GMT

Thanks Radhakrishnan...