Excel transformation

Dear madam, dear sir,

we're interested in purchasing your product for data mapping.
The use-case is to map data between 2 Excel files (source to destination).
Additional I would like to know, if it is possible, to map although, for example, cell F1 and F3 are named similar, e.g. width

J

Hi J.

Thank you for contacting us.

You came to the right place our ETL software can do a lot with Excel files

The best way for you to get started and to download and install Advanced ETL Processor enterprise.

www.etl-tools.com/advanced-etl-processor...rprise/overview.html

The trial has no limitations and it works for one month.

The use-case is to map data between 2 Excel files (source to destination).
Additional I would like to know, if it is possible, to map although, for example, cell F1 and F3 are named similar, e.g. width

There are multiple ways to perform the mapping all of them designed to save you time

Please watch our tutorials you may find them very useful

www.etl-tools.com/table/advanced-etl-processor/tutorials/

Ladies and Gentlemen,

currently we are testing the advanced ETL processor tool and evaluate how we can use it best for our specific use case.
Recently we have come across a problem.

Sometimes it is necessary to fill columns in excel, only if a certain value, for example the order number is given in the destination file.
In this very example, that you can see in the attachments, I would like to have AETLP check, if the order number in the destination file meets an order number in the source file.
And if so, I would like to have AETLP to fill the empty gaps, in this case name and description for example, but only if they're empty.

kind regards,

Basti

I am looking at it now.

May I suggest starting a new topic next time?

May I also suggest to you to provide us with actual excel files next time?
(I am sitting in the office and typing the data you want to use as en example manually into excel files)

Apologies for my prevous comments, I can see that you had sent excel files to us already.
Thank you

there is nothing to apologise for,

in fact im a forum virgin. Everthing is okay for me.

thank you for your effort.