Direct and indirect relation between data

[caneerajdwivedi]

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?