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
Would you be able to share your data model and explain what is going on?
the script is too long, but i show you a screenshoot, So i have to link OB_LINKTABLE TO AGENCE with the AGENCE(AGENCEC)
Are you using QUALIFY * before OB_LinkTable? If you are just add UNQUALIFY AGENCEC; after QUALIFY *;
Without qualify * ; i have problem with SYN TABLE
Leave the QUALIFY *, but also add UNQUALIFY AGENCEC;
So essentially do like this
Sunny i found that all others link are deleted
Can you share the screenshot of what happened?
sunny it ok i leave the unqualify with the first table link ,and i put
with the second link table
So you don't want these 4 columns to connect? or what is the issue?
avoid the SYnt tbale :/
You can create composite keys to get rid of synthetic keys.... read here
So sunny i can't create direct link ??? i mean that link 1------> lAGENCE / DATESITUATION
LINK 2 -----> AGENCE /DATE
WITHOUT PASSING BY SYNTH TABLE
Retrieving data ...