Excel column names in different order

Hi,
To update some specific fields in our ERP, we extract an excel file and send to our users.
Than we import the edited excel.

The thing is that our users are creative... They change order of the columns and also add news ones.
For instance:
We send them an excel file with columns: product, quantity, currency, unit price, total price
They send us back an excel file with columns: product, currency, quantity, unit price, total price, comments

What we need when importing is:
1. Check that the original 5 columns exists
2. Use those 5 columns even if they are not in the expected order.

Can Advanced ETL Processor handle this situation?

Thank you,
Roberto

Yes it is definitely possible, we will provide you with an example later today

Here is our example as promised

Actual transformation is attached

Thank you Mike!
I was thinking with a different approach and at the end what we need is to use a SELECT statement using the excel file as a source.
In your example it would be something like: SELECT [COMPANY NAME], [YEAR], [MONTH ID], [PRODUCT ID] FROM [TOTAL_SALES]
I tried setting up and ODBC connection with the Excel ODBC driver and it works but you have to specify the filename in the ODBC connection.
Considering the filename changes everytime, is there a way to have Advanced ETL Processor pass the filename as a parameter of the ODBC connection?

Thank you again,
Roberto

Roberto.

MS Excel ODBC driver is one big problem and most of the time it is JUST DOES NOT WORK.
We have stopped using it very long time ago
www.etl-tools.com/imex1.html