I have 5 datasets that are currently saved in File Maker Pro. If it makes it easier for you to construct the database, I can provide the datasets in excel or csv format.
Information about the data sets:
There is 1 main set of records, called AAAA, it is 630K records long and contains about 40 fields. These records each represent a piece of property and the fields contain characteristics and ownership information associated with that piece of property. Each of the records in the Dataset has has a unique identifier that ties it to the additional information about the records that may be present in 4 other data sets.
The remaining 4 data sets are between 20K and 250K records long and each contain between 3 and 50 fields of information that is associated with the original data set. This records include things such as postal information, transaction information about the property and other additional information about the property records. All of these records are marked by the unique identifier as well. There are no records here that are not present in the AAAA set, but as previously explained, not every record from AAAA has information in these datasets.
I need these 5 data sets combined into a relational database. I will need to the ability to pick and choose different fields from all 5 of the data sets so that I can run reports and analyze the data. This should not be difficult for anyone familiar with filemaker pro.
14 freelancers are bidding on average $84 for this job
Hello. I am very interested in your project and I would like to undertake it. I am responsible, hard-working and well-qualified in Excel. I hope you'll choose me.