× Data Warehousing and Data integration

Excel transformation

  • Posts: 5
  • Thank you received: 0

Excel transformation was created by jarrod

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
10 months 1 week ago #21676

Please Log in or Create an account to join the conversation.

  • Posts: 8628
  • Karma: 33
  • Thank you received: 590

Replied by admin on topic Excel transformation

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/
Mike
ETL Architect
10 months 1 week ago #21678

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 2

Replied by run71m3_3rr0r on topic Excel transformation

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
10 months 4 days ago #21695
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1286
  • Karma: 3
  • Thank you received: 165

Replied by Peter.Jonson on topic Excel transformation

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)
Peter Jonson
ETL Developer
10 months 3 days ago #21697

Please Log in or Create an account to join the conversation.

  • Posts: 1286
  • Karma: 3
  • Thank you received: 165

Replied by Peter.Jonson on topic Excel transformation

Apologies for my prevous comments, I can see that you had sent excel files to us already.
Thank you
Peter Jonson
ETL Developer
10 months 3 days ago #21698

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 2

Replied by run71m3_3rr0r on topic Excel transformation

there is nothing to apologise for,

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

thank you for your effort.

File Attachment:

File Name: Desti.xlsx
File Size:9 KB

File Attachment:

File Name: Source.xlsx
File Size:17 KB
The following user(s) said Thank You: Peter.Jonson
10 months 3 days ago #21699
Attachments:

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies