โ09-05-2017 04:54 AM
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.
โ01-23-2019 07:39 AM
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 ?
โ03-16-2019 01:28 PM
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.