Help needed with forming a transitive relation

[vibhore276]

I ran fuzzy mapping in alteryx and it generated a table with two IDs, where ID1 is the parent ID and ID2 is the ID that matches with ID1. However, the table has lot of circular references. As an example:

ID1 ID2
1 B
2 B
2 D
5 D
6 E
7 E
2 F
1 H
8 K
2 K

I want final table where all the circular references should be removed, essentially the Output for above table should be

ID1 ID2
1 B
1 2
1 D
1 5
6 E
6 7
1 F
1 H
1 K
1 8

I thank you all in advance for helping me out in generating the solution.

[Richard Buttrey]

Hi,

It's not clear to me what you mean by circular referencing, nor whether those IDs are references to columns & rows or just values.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and explain how you have arrived at your results, i.e. the process you went through to derive the results.