Your challenge is confusing;) What I see when i open your workbook
a. Candidate Info
The Datasource Candidate Info consist of 2 tables
a. Table Candidate Info
b. Independent Expenditures
If I look at the structure of the tables Independent Expenditures en Expenditures is identical.
Without further investigation of the datasource "Candidate info" I assume the join between tabel candidate info and Independent Expenditures is not correct based on Last Name, District and State. I would have expected just to join in Candidate Id
Hope to hear from you.
This is a very tough problem that I have been working on for awhile to solve.
So to give you a little bit more information, the independent expenditure data is the data that I need to be able to match up with the results10 data connection. Within the results10 data connection, I need to use the 2010 US House and Senate results data. I need to be able to join those two, the problem is that if you look within just the Independent Expenditure data, some candidates do not have their candidate ID listed for every entry. Thus resulting in wrong data when I do a join.
The data set Candidate Info is all of the candidates from that year and lists all of their candidate IDs. What I would like to do is be able to join Candidate Info and Independent Expenditures to then be able to set all of the missing candidate IDs within Independent Expenditures based off of last name, district, and state.
Hopefully that gives you a little more of a background.
If you have any questions, please let me know.
Thanks for your help!