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