Aggregate Data from Files
Last updated: 23 Dec 2022
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.