Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Removing Synthetic Keys Made by EMP_id,Date,Year,Month,Period

Hi,

I have five tables A, B, C ,D , E and other Master file which have employee description. When I am loading it , It creates Synthetic Table which consists of EMP_id,Date.Year.Month,Period and Quarter.

Please suggests me the best way to avoid this and keeping association perfect.

Thanks in advance.

3 Replies
Master III
Master III

Re: Removing Synthetic Keys Made by EMP_id,Date,Year,Month,Period

- Join the tables to create a single big table

Or

- Create Keys using Autonumber() and rename similar name fields as below

Load EmpId, Year, Autonumber(EmpId&Year) As EmpKey Table Employee

Load EmpId As EId, Year As Yr, Autonumber(EmpId&Year) As EmpKey Table Employee

Highlighted
MVP
MVP

Re: Removing Synthetic Keys Made by EMP_id,Date,Year,Month,Period

before removing it tries to read this post to see if you actually have to remove them

Synthetic Keys

if you still want to remove you can use

- autonumber as already suggested

- field1 & '|' & field2 & '|' & field3 as %key

- renaming fields

Best way depends on your model, if possible post it (table viewer)

Highlighted
Contributor III
Contributor III

Re: Removing Synthetic Keys Made by EMP_id,Date,Year,Month,Period

export.png

This is the Data Model...Please prefer me the best way to avoid it