I have 2 CSV Files that I need to Combine into one file before I can join them to my spatial data. The files are part of the same dataset but exceed the row limits for excel, so a simple copy / paste is not an option. If I join them to the existing spatial data by their Record ID the first join goes fine, however the 2nd join creates an unwanted duplication of the fields. This leaves me with only the option of combining the original CSV data then completing the join. For some reason I can't seem to find a way to do this in ARCPRO. Can anyone point me in the right direction?
