troubleshooting Question
Query comparing two tables with different format needed.
asked on
Hi Experts,
I need to compare two files containing same data with different format.
They have following columns
Patients Name
Caregiver name
Visit Date
Visit time from
Visit Time to
would need to get a list of all unmatched records.
its only considered a match if all 5 fields are the same.
Attached sample of those files, where record in both files is considered a match.
Here are the differences, one of the files has the following
1- first and last name concatenated into one field.
2- has data in parenthesis after the names which should be ignored.
3- format of time is 1459-2304
Visit-Report.xls
V_TestHHASchedule.xls
I need to compare two files containing same data with different format.
They have following columns
Patients Name
Caregiver name
Visit Date
Visit time from
Visit Time to
would need to get a list of all unmatched records.
its only considered a match if all 5 fields are the same.
Attached sample of those files, where record in both files is considered a match.
Here are the differences, one of the files has the following
1- first and last name concatenated into one field.
2- has data in parenthesis after the names which should be ignored.
3- format of time is 1459-2304
Visit-Report.xls
V_TestHHASchedule.xls
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
This award recognizes a member of Experts Exchange who has made outstanding contributions to the community within their first year as an expert. The Rookie of the Year is awarded to a new expert who has the highest number of quality contributions.