1 of 1 people found this helpful
it looks like you have blended the data - in so doing you have duplicated the records matching up on account name - so each value of jim brown in file 1 will match up with every value of jim brown in file 2
try joining on account number
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim, i'm giving this a go and will let you know how it goes!
Thanks for the quick reply!
Hi Jim! Sorry it took me so long to reply! but it was an error with my joins! Thank you so much!
Glad you got what you needed
Enjoy the weekend