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?