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?
