Diff snap strange thing

[bobyin]

Guys, a silly question, want to compare two data,

One is like email, full_name, title, licenses, uid.
One is like email, full_name, title.

Sorted by email.

When I check the modified output, found the user with same email, full_name and title, do you know why?

Thanks.

[pavan44]

Hi,
I do have two tables and I am comparing them using Diff Snap.

Table A (New):
“EMP ID”: “00001”
“EMP Name”: “Jackson, Micheal”
“Position ID”: “00002”
“Manager EMP ID”: “1002080”
“Manager Position”: “00217”
“Manager Name”: “ABC”
“Manager Sup Org”: “XYZ”

Table B (Original):
“EMP ID”: “00001”
“EMP Name”: “Jackson, Micheal”
“Position ID”: “00002”
“Manager EMP ID”: “1002080”
“Manager Position”: “00217”
“Manager Name”: “ABC”
“Manager Sup Org”: “XYZ”

“EMP ID”: “00001”
“EMP Name”: “Jackson, Micheal”
“Position ID”: “00002”
“Manager EMP ID”: “1315186”
“Manager Position”: “00591”
“Manager Name”: “DEF.”
“Manager Sup Org”: “LMN”

Since, Both the tables has employee ID with different Managers under same position. Can we do the comparison still?. If yes, can you please explain.

The reason is I am not seeing the second record from the Original table in the output of Diff Snap either as Modified or Insertion or deletion or unmodified. Any reason ?

[aleung]

Were you able to figure it out?

The diff snap expect your sort path to be unique but in your case your 2nd record in your sample have the same employee ID.