[resolved] Search view composite with many to many relationship

Highlighted
Five Stars

[resolved] Search view composite with many to many relationship

Hi all,
I have a simple model with Customer, Address, CustomerAddress. Relation N-N between Customer and Address (aggregation) is declared in Customer  : Customer/AddressList String with foreign key to Address. Is it possible to create a search view to retrieve Customer fields and list of attached adresses  ?
Thks,
Pat

Accepted Solutions
Five Stars

Re: [resolved] Search view composite with many to many relationship

Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view? 

Hello Willm, nothing special I have just made a view like this :
=> Customer properties
Customer/CustomerId
Customer/CustomerName
...
=> Customer adresse relation properties
Customer/AddressList/AddressLabel
Customer/AddressList/AddressTypeOf
...
=> Adresse properties
Address/AddressId
Address/AddressIdEM
...
and I add the followinf join :
Customer/AddressList/Address join with Address/AddressId

Pat

All Replies
Five Stars

Re: [resolved] Search view composite with many to many relationship

I finally found.

Four Stars

Re: [resolved] Search view composite with many to many relationship

Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view? 
Five Stars

Re: [resolved] Search view composite with many to many relationship

Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view? 

Hello Willm, nothing special I have just made a view like this :
=> Customer properties
Customer/CustomerId
Customer/CustomerName
...
=> Customer adresse relation properties
Customer/AddressList/AddressLabel
Customer/AddressList/AddressTypeOf
...
=> Adresse properties
Address/AddressId
Address/AddressIdEM
...
and I add the followinf join :
Customer/AddressList/Address join with Address/AddressId

Pat

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.