Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Structure differ from in Table Viewer

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,

Table.bmp

But Source Table View no synthetic fields,

Table.bmp

Could you please clarification?

Regards,

Raja.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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. 

View solution in original post

8 Replies
MK_QSL
MVP
MVP

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
Master III
Master III

Hi Raja,

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

Thanks,

AS

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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
MVP
MVP

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. 
Not applicable
Author

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.

Not applicable
Author

Thanks Radhakrishnan...