Discussion Board for collaboration related to QlikView App Development.
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.
- 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
before removing it tries to read this post to see if you actually have to remove them
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)
This is the Data Model...Please prefer me the best way to avoid it