The excel file is autogenerated overnight from a system. I understand that having two different fields with same name is not the best practice for database. But they are from other department and for now I don't have any control over the field name.
There are two fields both called 'Status' but containing different data.
I should clarify that I am loading one excel file. And there are two different fields with same name in the same excel file. And the field has nothing to do with 'Departments'. It is just that the data is provided by other departments, not the department I am in.
I try to rename one of the 'Status' field (lets say I rename to 'Status_new') but the result is both 'Status' and 'Status_new' are the same field. So one of the original 'Status' field are ignored.
The excel load has a bit of magic. If you use the "embedded labels" option, the first column labeled "Status" will be known as "Status". The second column labeled "Status" will be known as "Status1". So a generated LOAD statement, or one you code yourself will look like:
From xxx (biff, embedded labels,,,)
Even though both columns have the heading "Status".