Not sure but I think you can 'union' the Hotel & Office file when the structure of both files is the same.
Hope it helps,
1 of 1 people found this helpful
Agreed with Norbert's suggestion for unioning the files - that's the easiest if you have files with the same or similar structure.
If that doesn't work, you can also try a full outer join with non-matching fields (I often use calculated fields and set 0 = 1). You would then just make a new calculated latitude field and longitude field that fill in the corresponding location from each (e.g., if the coordinate comes from hotels, drop that in the new column; if the coordinate comes from offices drop that in the new column). If you have a third new column that specifies which dataset it which (e.g., which rows are hotels and which are offices) you can use that to easily disambiguate the locations.