Data Warehousing and Data integration

Import from Excel: Smart Mapping on Random Field Names

1 year 1 month ago #22093 by Antonio

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,

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

1 year 1 month ago #22094 by admin
Thank you for contacting the support

Please have a look at the following forum post

I hope you will find the information provided useful

ETL Architect

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

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Set of techniques which have for object the commercial strategy and in particular the market study.
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Tools used to give you more features when navigating on the website, this can include social sharing.