ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
alteryx Community

# Alteryx Designer Discussions

## Direct and indirect relation between data

5 - Atom

Hi All,

I've a situation where some directors are related with each other through indirect or direct relationships. Let me explain the same through a table :

 Company Director A Mr. X A Mr. Y A Mr. Z B Mr. Y B Mr. U C Mr. T C Mr. V D Mr. U D Mr. R

Now since the database is small i know that relationship is as below :

Related parties of Company A:

 Party Relation Mr. X Direct Mr. Y Direct Mr. Z Direct Company B Direct, because Mr. Y is a director in both company Mr. U Direct, because Mr. Y is a director in both company and Mr. U is in one of those company Company D Indirect, because Mr. U is a director in Company B where Mr. Y is also a director Mr. R Indirect, because another Director Mr. U is a director in Company B where Mr. Y (Director of Company A)is also a director

Related parties of Company B:

 Party Relation Mr. X Direct, because Mr. Y is a director in both company A and company B Mr. Z Direct, because Mr. Y is a director in both company A and company B Mr. Y Direct Mr. U Direct Particulars Direct, because Mr. Y is a director in both company and Mr. U is in director in Company B Company D Direct, because Mr. U is a director in both company B and company D Mr. R Direct, because Mr. U is a director in both company and Mr. R is in one of those company

Related parties of Company C:

 Party Relation Mr. T Direct Mr. V Direct

Related parties of Company 😧

 Party Relation Mr. X Direct, because Mr. U is a director in both company B and company D Mr. Y Direct, because Mr. U is a director in both company B and company D Mr. Z Direct, because Mr. U is a director in both company B and company D Company B Direct, because Mr. U is a director in both company B and company D Mr. U Direct, because Mr. U is a director in both company B and company D Mr. R Direct Company  A Indirect, because Mr. U is a director in Company B where Mr. Y is also a director

Whether the same can be achieved in Alteryx anyhow for a larger database of apprx 10 million line items?

Labels