Exercise
You're a sales manager tracking sales for a few stores. Given three flat files with sales data per store (DailySales_Store1.csv
, DailySales_Store2.csv
and DailySales_Store3.csv
), produce a flat file that aggregates sales data ("Quantity", "Revenue") at the total store level.
Hints
Read through Flat File Source, Filter, Union, Aggregate, and Flat File Export.