Thank you for taking the time to reply fabriciocarboni. Did you create the python script in snaplogic? If so did you have to install any python packages to get it to execute?
Hi snapation6713,
No, our Snaplogic subscription does not have RPE. So I had to develop the script and run it from my local machine.
Is the data coming in flat or as an array?
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.
