This tutorial is for imports where the source layout is more awkward than a normal flat file. Visual Importer ETL can help load pivot-table style data into a database table.
What You Will Learn
- Recognise when the source layout behaves like a pivot table.
- Prepare the import for data that is not in a simple flat structure.
- Load pivot-table data into a database target.
- Check the imported result before using it in later reporting.
Before You Start
Use a copy of the source file while testing the import. Pivot-table layouts are useful for humans, but databases usually prefer tidy rows and columns. Databases are not known for their artistic temperament.
Need Visual Importer ETL First?
Download the Visual Importer ETL trial before following the tutorial, or review the product page if you are comparing editions.