How to resolve Synthetic keys created on Link Table in QS

[SwetaSule]

Hello All,

I have 3 tables and  have created link table on these tables. Issue is that synthetic table is getting created on my link table.

Please can anyone provide me the solution on this.

Thanks In Advance. 

[justISO]

Hi, can you provide at least data model view how it looks now? Its hard to solve this without anything.

[SwetaSule]

Please find the attachment - Data modeling

[SunilChauhan]

you Can create  Composite Key

i.e if more than  on column is common in two Tables

Table1:

Load  A,B,c

From Table 1

Table 2:Load  A,B,D,E

From Table 2

Then you Can do below

LOAD 

A&B as COmpositeKey,

A,B,

C

From Table 1

Load A&B as COmpositeKey,

D,E

Resident Table2;

Drop Tables Table1,Table2;

or you Merge two Tables if possible.

[SwetaSule]

Thank you for providing the solution. I have concatenated the tables.