ETL and Data Integration tools - Modern ETL software for everyone

Help me please

I'm trying to move data from a source file (excel) to a target file (also excel). The source and target files have the exact same field names.

I tried to use automap in the Transformation Editor to automatically link the fields by the same field name,
But when i click on MapNow, it only links a couple of the fields together not all of them.
What am I doing wrong?
Sincerely,

Mike

Michael

There are a lot of different options available on the auto map screen designed to make you life easier.

One of them is 'Ignore Case Difference'

That the one you should tick

Peter

Great call - the automap now works perfect. Thanks!!!

Sincerely,

Mike