I have a large transaction data set in the millions and around a 100 positional points. I need to join the transaction data set to these points. ArcMap won't let me join them without errors or if it does allow it null values are applied to the join.
They have a common field, a meter number for the machines. I have tried using a simple join with the attribute tables. My end goal is to be able to upload this data to an enterprise and integrate it into an operations dashboard. This dashboard would be able to tell the user the number of transactions with the machine within a time period. The transaction data set also has the date attached to it.
I am using ArcGIS Desktop 10.0.
I found a problem. The one web service map I am using has the meters as strings so in the transactions attribute table I added a new field and made it a text. Using the field calculator I added the meter number I was then finally able to perform the join, but only 153 values are in this join meaning it didn't join everything I wanted.
How can I get all of the values to join?