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

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

Anonymous — Sun, 01 Mar 2015 07:28:50 GMT

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.

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

anbu1984 — Sun, 01 Mar 2015 08:00:49 GMT

- Join the tables to create a single big table

- 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

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

maxgro — Sun, 01 Mar 2015 08:15:23 GMT

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)

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

Anonymous — Sun, 01 Mar 2015 11:44:29 GMT

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