× Data Warehousing and Data integration

Import from Excel: Smart Mapping on Random Field Names

  • Posts: 12
  • Thank you received: 0

Import from Excel: Smart Mapping on Random Field Names was created by Antonio

Hello,

I have a question about creating a large excel import.

I would like to create a large excel import based on a much larger dataset. For example, I may have 10 fields I want to import that have consistent field names.

However, a client may only send me 7 of the 10 total fields.

Is there a way to make the import intelligent so that it can know to only work with the 7 fields based on the field name (not position)?

If possible, this would be a game-changer for me. I could create very intelligent imports from excel that worked very dynamically based on whatever field names were provided. If there is not a field provided, it would just come in assumed as Null.

Thank you,
Toni
1 month 1 week ago #22093

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

  • Posts: 8551
  • Karma: 33
  • Thank you received: 578

Replied by admin on topic Import from Excel: Smart Mapping on Random Field Names

Thank you for contacting the support

Please have a look at the following forum post

www.etl-tools.com/forum/advanced-etl-pro...columns.html?start=0

www.etl-tools.com/articles/processing-fi...ositions-part-2.html

I hope you will find the information provided useful
Mike
ETL Architect
1 month 1 week ago #22094

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