topic Re: How to resolve Synthetic keys created on Link Table in QS in App Development

How to resolve Synthetic keys created on Link Table in QS

SwetaSule — Fri, 26 Aug 2022 09:40:52 GMT

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 — Fri, 26 Aug 2022 09:43:38 GMT

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

SwetaSule — Fri, 26 Aug 2022 11:25:22 GMT

Please find the attachment - Data modeling

SunilChauhan — Fri, 26 Aug 2022 14:43:01 GMT

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,

From Table 1

Load A&B as COmpositeKey,

D,E

Resident Table2;

Drop Tables Table1,Table2;

or you Merge two Tables if possible.

SwetaSule — Thu, 01 Sep 2022 08:49:31 GMT

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