Transforming Pivot data using Advanced ETL Processor |
|
Advanced ETL Processor UnPivot object transforms one record from pivot table into multile records using pivot groups. You may find more information about Pivot tables here  Pivot Table Example
To change UnPivot properties double click on the object. Fill in Description, Group field name, create all necessary Groups and Outputs. Once it is done Map input fields to outputs and Groups.
Result of transforming Pivot Table
Working with Pivot Transformation Object Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now. |
Testimonials
|
My boss told me to keep looking for a more expensive application, assuming Visual Importer ETL couldn't be very good because the price was just too low. After testing several imports I convinced him that Visual Importer did everything we want so there was no need to pay for a more expensive solution. Ron Bradshaw, |
Free Newsletter
Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.
