Synthetic Key Issue

[#1]

Hi,

I am pretty new to QlikView and its my first work. I am facing a issue with synthetic keys. I will expalin the details.

I have the following tables

1.   Store Table (Master Table)

2.   Drivers Table(Master Table)

3.   Agents Table(Master Table)

4.   Pick Table

5.   Process Table

6.   Grade Table

7.   Customer Table (Master Table)

8.   SalesDetails Table

9.   ArTable

10. Trailer Table (Master Table)

11. Group Table (Master Table)

Most of the transaction tables containing more than 20 crores of data.

I have attached the relation as a image.

For the simplicity of work i created each transaction table as a qv file. But now the client need it as a single file.

When i tried to connect them a lot of synthetic keys are generated and qlikview hangs. I need to avoid the synthetic key and maintain the relation, because each transaction tables are connected and there are a lot of comparisons are taking place between them.

I would be thankful if anyone can solve this issue.. Please reply ASAP.

Thanks in Advance..

[#2]

hi ,

you can remove the synthetic key by Aliasing the fields name using "as".

First concatinate the Transcational tables Pickup,Process and Grade Table and then u can link the Store ,agent , driver and trailer tables to them.

Similarly Concatinate the Sales and Ar table then link the customer Noand Grading to this concatinated table.

[#3]

Thanks, I will try with that