Table Structure differ from in Table Viewer

[#1]

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.

[MK_QSL]

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

[amit_saini]

Hi Raja,

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

Thanks,

AS

[jonathandienst]

Hi

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

[#5]

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.

[maxgro · Accepted solution]

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. 

[#7]

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.

[pandiarajan]

hello raja,

Read Below link

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

[#9]

Thanks Radhakrishnan...