Renaming 2 fields to one common field name

[Anonymous]

Hi

I have 2 fields Primary Owner and Secondary Owner with incorrect names. Hence i have created a mapping table to map the incorrect values with the correct names.

I have used applymap('maptable',Primary Owner) as Owner field.

When I try to use applymap('maptable',Secondary Owner) as Owner it doesn't allow me to do it as this field already exists. has anybody faced a similar issue like this..IF there a workaround for this please let me know

[Anonymous]

Thanks Stefan..I was successfully able to concatenate the files and generate a canonical table as suggested. I just removed the earlier fields from it and reloaded it later and it worked.