I have joined three sheets from an Excel file to a shapefile. Each sheet contains ACS data so some of the field names are duplicated. (Example: HC03_V17 is present in all three sheets: Economic, Social and Demographic.) This seems ok because when I look at the joined table before exporting it to a shapefile the titles contain a prefix for the sheet they came from and the actual ACS code that I can look up in the metadata file (see below).
When I export though I lose that naming convention. Instead, Codes like Economic$.HC03_V17 are transformed into something like Economic_12. This makes it quite difficult to go back to the ACS metadata and determine what that field data measures.
Is there a way to maintain the naming conventions that appear when I first add the join?