Giving 2 fields from different spreadsheets the same name
I have 2 spreadsheets that follow a similar format. What would happen if I load the data and give 2 fields from each of these sheets the same name? Would it become 1 field with all of the instances or would it be something along the lines of 'Sheet1.Labels' and 'Sheet2.Labels'? I want to create 1 field.
If you have two spreadsheets and they have different field names in them, creating a field with the exact same name in each table will join them. If you don't want them to join/associate, you have to force concatenate them.