Aggregate data from multiple columns

I am attempting to aggregate (or subtotal) the number of cars by destination whse and then by PLA (date field).  The yellow column below shows the output that I am looking to create.  Beast mode? SQL data flow?  ETL?


Any help here would be appreciated.




Best Answer

  • user03357
    Answer ✓

    Here's the first thing that came to my mind:


    Full ETL:

    Full Flow.JPG


    Group by:


    Group By.JPG

    Join Data:



    Select Columns:


    Select Columns.JPG


    Let me know if you have questions.