Linking three entities in MDM Data Model

djugal — Sat, 16 Nov 2024 05:07:07 GMT

Hi,

Have an issue where I need to check and join 3 entities. I want Country names of students to be displayed but only those countries which are in EMEA

Student (Name Status CountriesID)

AllCountries (ID Name)

EMEACountries (Name Area Nation)

So now for my column Student / CountriesID join to AllCountries / ID

Then have a FK filter AllCountries / ID contains EMEACountries / Name

but I get the error saying that 'CONTAINS' support not implemented for field to field comparison.

Can you tell me how I can do this join

Re: Linking three entities in MDM Data Model

Anonymous — Mon, 19 Aug 2019 03:50:51 GMT

Hello,

If we got your question right, .since our tMDMInput works on pro entity base and you could get the fk id and then query all the entity with that fk. Let us know if it is what you are looking for.

Best regards

Sabrina

topic Linking three entities in MDM Data Model in Talend Data Catalog

Linking three entities in MDM Data Model

Re: Linking three entities in MDM Data Model