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) | F2 | F3 | F4 | F5 | F6 | … |
001 | a | b | c | d | e | |
001 | a | B | c | d | e | |
002 | f | g | h | i | j | |
002 | f | g | H | i | j | |
003 | k | l | m | n | o | |
003 | K | l | M | N | o | |
… |
Output | |
F1 (ID) | Changed_Field |
001 | F3 |
002 | F4 |
003 | F2 |
003 | F4 |
003 | F5 |
@CoG @nagakavyasri Thank you both for your nice solutions :)
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |