Working with Pivot Transformation Object |
|
Advanced ETL Processor Pivot object creates pivot tables from flat data sources. You may find more information about Pivot tables here
Source data example Pivot Table
Since there are more than one field to pivot let’s join Profit and Sales fields together first using tab a delimiter than pivot the data and split it again
Joining the data
Data after Pivoting
Splitting Pivoted Data |
Testimonials
Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer was the answer to the lack of VB skills problem my group experienced.Ron Bradshaw, IT Reporting Manager, ConAgra Foods / Lamb Weston |
Free Newsletter
Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.
