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: 
Anonymous
Not applicable

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

- 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

maxgro
MVP
MVP

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)

Anonymous
Not applicable
Author

export.png

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