how to create a link table

[michael_maeuser]

Hi, I have many tables in my data model. If I link all tables to the calendar i get many syn tables and circular references. Now i want to solve the problem with a link table. i googled a lot but still don´t understand how to do that exactly. For example I have 5 tables: Vendors (Fields: %Vendor,Name etc.) , Vendor ledger entry (%Vendor, Amount, Posting Date, item), Customer (Fields: %Vendor,Name etc.), Customer ledger entry (%Debitor, Amount, Posting Date, item) and Calendar.  By the way I have also som left joins in my script. Is it true that I have to avoid them if I work with link tables?Thanks! Michael

[vijay_iitkgp]

Hi ,

If you can share your current table view then it will be easy for us to ynderstand.

[michael_maeuser]

see attached...

[CELAMBARASAN]

Hi,

     Try with this approach

     Make a key with the fields which creates synthetic key and change that fields names to be differ in both the table.You can use qualify instead of changing the field names.

For Example:

     Load Field1&Field2 as Key, Field1, Field2..From..

     Load Field1&Field2 as Key, Field1 as Field3, Field2 as Field4..From..

Which makes the key to link between 2 tables.

Hope it helps

Celambarasan