We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

compare two rows for multiple columns

IMSL
7 - Meteor

Hi all,

 

I have table with many rows and columns.

Every two rows have a unique ID (always applies).

How can I compare each two rows with identical ID to figure out any discrepancies in any of the columns?

 

Input      
F1 (ID)F2F3F4F5F6
001abcde 
001aBcde 
002fghij 
002fgHij 
003klmno 
003KlMNo 
      

 

 

Output 
F1 (ID)Changed_Field
001F3
002F4
003F2
003F4
003F5
3 REPLIES 3
CoG
14 - Magnetar

Transpose Tool is the MVT (Most Valuable Tool) in this circumstance although there are some other preparations that are required (notice the filter that separates pairs of records into 2 separate data streams, that are joined for comparison):

Screenshot.png

 

Hope this helps and Happy Solving!

nagakavyasri
12 - Quasar

@IMSL Another way:

 

Screenshot 2024-11-22 135418.png

IMSL
7 - Meteor

@CoG @nagakavyasri Thank you both for your nice solutions :)

Labels
Top Solution Authors