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
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.
