NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Working with Pivot and Sorter

In this tutorial, you will learn how to use Advanced ETL Processor to create a simple data transformation. The transformation that you create takes data from a text file, sorts the data, performs pivot transformation and then saves the data into new text file. In following lesson, the transformation will be expanded to demonstrate connection configurations, logging and error flow.

GroupID,Name
2,Alex
1,John
1,Peter
4,Jessica
1,Simon
2,Vincent
3,Mary
4,Martin
=> GROUPID,NAME
1,Peter,Simon,John
2,Alex,Vincent
3,Mary"
4,Martin,Jessica

The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processor  is to use them. This tutorial walks you through Data transformation to create a simple ETL package.

This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor.

All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

"Using Active Table Editor is the easiest way of editing lookup tables  I've ever seen. A free 30-day trial is available on their Web site; the only issue is that when the 30 days are up, you're going to want to buy it."
- Moo Ling, Software Enginier

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with