Diff snap strange thing

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.

Is the data coming in flat or as an array?

Hi, sorry to reply late, it’s like this(previewed results, will be more),

New:

Thanks.

Original:

keep in mind it is compare the whole row btw New and Original. you will get 100% of the the New as modified if you don’t have identical columns.

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 ?

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.