ETL and Data Integration tools - Modern ETL software for everyone

Hi all,

I am new to all this data transformation and ETL stuff.
and if someone can guide me for for the below it would be great

my source file is is something like this

Customer ID|Customer Name|ItemID|ItemName|SalesAmount
1 |John Smith |1 |Item 1 |100
1 |John Smith |1 |Item 1 |3000
2 |Steeve Gates |2 |Item 2 |11200
2 |Steeve Gates |2 |Item 2 |124
2 |Steeve Gates |2 |Item 2 |122

I want to split it into two table one of the will hold

Sales by customer
Customer ID; Customer Name;TotalSales
1;John;30100
2;Steeve Gates;50566

Another sales by Item
ItemID;ItemName;SalesAmount
1 |Item 1 |100
2 |Item 2 |11200

The number do not match but it does not matter

Thanks in advance
Regards
Peter R

Advanced ETL processor would be the best option for you
Installation has an example of how it can be done.

Peter