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

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Direct and indirect relation between data

caneerajdwivedi
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 :

CompanyDirector
AMr. X
AMr. Y
AMr. Z
BMr. Y
BMr. U
CMr. T
CMr. V
DMr. U
DMr. R

 

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

 

Related parties of Company A:

PartyRelation 
Mr. XDirect
Mr. YDirect
Mr. ZDirect
Company BDirect, because Mr. Y is a director in both company
Mr. UDirect, because Mr. Y is a director in both company and Mr. U is in one of those company
Company DIndirect, because Mr. U is a director in Company B where Mr. Y is also a director
Mr. RIndirect, 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:

PartyRelation 
Mr. XDirect, because Mr. Y is a director in both company A and company B
Mr. ZDirect, because Mr. Y is a director in both company A and company B
Mr. YDirect
Mr. UDirect
ParticularsDirect, because Mr. Y is a director in both company and Mr. U is in director in Company B
Company DDirect, because Mr. U is a director in both company B and company D
Mr. RDirect, because Mr. U is a director in both company and Mr. R is in one of those company

 

Related parties of Company C:

PartyRelation 
Mr. TDirect
Mr. VDirect

 

Related parties of Company 😧

PartyRelation 
Mr. XDirect, because Mr. U is a director in both company B and company D
Mr. YDirect, because Mr. U is a director in both company B and company D
Mr. ZDirect, because Mr. U is a director in both company B and company D
Company BDirect, because Mr. U is a director in both company B and company D
Mr. UDirect, because Mr. U is a director in both company B and company D
Mr. RDirect
Company  AIndirect, 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