[resolved] Search view composite with many to many relationship

Highlighted
Six 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
Six 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
Six 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? 
Six 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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download