How to get this ScriptPlease send Email with Subject "Multiple Column Compare" to vijkid143@gmail.com for Zip File
Note: Customization can be done on Request
Description
This Script will compare the data between two files having MultipleColumns with multiple records
How to Use it
Prerequisites
1) First download the data from Database or Reports or some other Source in Excel spread sheets. You should have 2 Excel Sheets each having a data set to compared.
Run the Script
1) Download the zip file (Please send Email with Subject "Multiple Column Compare" to vijkid143@gmail.com for Zip File)
2) Unzip the Files
3) Simply Copy the Data from first Excel spreadsheets into File1.txt and second Excel Spreadsheet into File2.txt and save them
4) Run the Script GET_MATCHING_RECORDS_OF_FILE1.vbs
5) Enter the Number of Columns present in File1.txt and Click Ok
6) Enter the Primary Column Position Number. For Example. If Primary Column in in 4th Position Then Enter 4.
6) Once script execution is completed. Open the "Matches.txt" and "NoMatches.txt" files and "MatchesID_NoMatchesColumns.txt" Files
7) Matches File will have the exact Matches between File1 anfd File2
8) NoMatches file will have the PrimaryKeys Values present in File1 which are not present at all present in File2. In the sense there is no record at all
9) MatchesID_NoMatchesColumns.txt will have Primary Key Matches. But there will be atleast one mismatch in the rest of the Columns
Note: To find out the "Records present in File2 not present in File1". Run the other script "GET_MATCHING_RECORDS_OF_FILE2.vbs" which works the otherway round
Visit My Other Blogs
http://exceljoins.blogspot.in/
http://wordcount-vbscript.blogspot.com/
Developed By: Vijay Uppara (Vijaya Bhasker M Uppara)
Please send your comments or Feedback to vijkid143@gmail.com
Note: Customization can be done on Request
Description
This Script will compare the data between two files having MultipleColumns with multiple records
How to Use it
Prerequisites
1) First download the data from Database or Reports or some other Source in Excel spread sheets. You should have 2 Excel Sheets each having a data set to compared.
Run the Script
1) Download the zip file (Please send Email with Subject "Multiple Column Compare" to vijkid143@gmail.com for Zip File)
2) Unzip the Files
3) Simply Copy the Data from first Excel spreadsheets into File1.txt and second Excel Spreadsheet into File2.txt and save them
4) Run the Script GET_MATCHING_RECORDS_OF_FILE1.vbs
5) Enter the Number of Columns present in File1.txt and Click Ok
6) Enter the Primary Column Position Number. For Example. If Primary Column in in 4th Position Then Enter 4.
6) Once script execution is completed. Open the "Matches.txt" and "NoMatches.txt" files and "MatchesID_NoMatchesColumns.txt" Files
7) Matches File will have the exact Matches between File1 anfd File2
8) NoMatches file will have the PrimaryKeys Values present in File1 which are not present at all present in File2. In the sense there is no record at all
9) MatchesID_NoMatchesColumns.txt will have Primary Key Matches. But there will be atleast one mismatch in the rest of the Columns
Note: To find out the "Records present in File2 not present in File1". Run the other script "GET_MATCHING_RECORDS_OF_FILE2.vbs" which works the otherway round
Visit My Other Blogs
http://exceljoins.blogspot.in/
http://wordcount-vbscript.blogspot.com/
Developed By: Vijay Uppara (Vijaya Bhasker M Uppara)
Please send your comments or Feedback to vijkid143@gmail.com
No comments:
Post a Comment