Hi All -
(Big breath) I hope this isn't too embarrassingly easy, but here goes:
I have a 6k row XLSx file called October
first col: empl_id (unique)
25+ cols of 'other' fields
I have a file with 6k +/- rows called November
I can open the two in the trial of beyond compare, and see them lined up by empl_id, and highlight the rows that are new, deleted and changed. (WAY AWESOME!!!)
I think I can figure out which columns to ignore. But here's the question:
How do I output an XLSx file that only includes all the New records, Deleted Records and Changed records? In other words if there were 15 new ones added, 45 old ones deleted, and 45 changed, this file should contain 105 records grouped as added, deleted, changed.
Thanks in advance for any help!
Dan
(Big breath) I hope this isn't too embarrassingly easy, but here goes:
I have a 6k row XLSx file called October
first col: empl_id (unique)
25+ cols of 'other' fields
I have a file with 6k +/- rows called November
I can open the two in the trial of beyond compare, and see them lined up by empl_id, and highlight the rows that are new, deleted and changed. (WAY AWESOME!!!)
I think I can figure out which columns to ignore. But here's the question:
How do I output an XLSx file that only includes all the New records, Deleted Records and Changed records? In other words if there were 15 new ones added, 45 old ones deleted, and 45 changed, this file should contain 105 records grouped as added, deleted, changed.
Thanks in advance for any help!
Dan
Comment