problem with table LINK

[souadouert]

I have two table link table with a same column of other table,  I have to make so that this table link 1 link2 connects with the same other table without a table SYN

[sunny_talwar]

Would you be able to share your data model and explain what is going on?

[souadouert]

hello Sunny,

the script is too long, but i show you a screenshoot, So i have to link OB_LINKTABLE TO AGENCE with the AGENCE(AGENCEC)

[sunny_talwar]

Are you using QUALIFY * before OB_LinkTable? If you are just add UNQUALIFY AGENCEC; after QUALIFY *;

[souadouert]

Without qualify * ; i have problem with SYN TABLE

[sunny_talwar · Accepted solution]

Leave the QUALIFY *, but also add UNQUALIFY AGENCEC;

So essentially do like this

QUALIFY *;

UNQUALIFY AGENCEC;

OB_LinkTable:

LOAD .....

[souadouert]

Sunny i found that all others link are deleted

[sunny_talwar]

Can you share the screenshot of what happened?

[souadouert]

sunny it ok i leave the unqualify with the first table link ,and i put

QUALIFY *;

UNQUALIFY AGENCEC;

with the second link table 

[souadouert]