Contents x
    Aggregate Data from Files
    • 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Aggregate Data from Files

    • Updated on 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    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.


    Answer Key

    Clean and Aggregate Multiple Text Files

    Was this article helpful?
    What's Next