Results 1 to 2 of 2

Help needed with forming a transitive relation

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2018
    Location
    Bellevue
    MS-Off Ver
    2016
    Posts
    1

    Help needed with forming a transitive relation

    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.
    Last edited by vibhore276; 03-06-2018 at 08:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using conditional forming of a cell to change the color of a chart.
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2017, 02:20 PM
  2. Forming a URL with a querystring
    By KK33317 in forum Excel General
    Replies: 2
    Last Post: 04-09-2016, 03:21 PM
  3. i need help forming a new formula for a chart im making
    By nancy.alibaba in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2013, 05:22 PM
  4. Forming String from Selected Items
    By bstubbs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2009, 06:57 PM
  5. forming an IF statement function
    By Tony_t in forum Excel General
    Replies: 5
    Last Post: 01-01-2009, 10:13 AM
  6. Distributing elements forming n groups
    By mrbenit@yahoo.es in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2005, 09:05 AM
  7. conditional forming causing linking errors
    By Dave Breitenbach in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-01-2005, 03:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1