Aggregate data from multiple columns

user04819
user04819 Member
in Magic ETL

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.

 

 Capture.PNG

 

Best Answer

  • user03357
    user03357 Member
    Answer ✓

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

     

    Full ETL:

    Full Flow.JPG

     

    Group by:

     

    Group By.JPG

    Join Data:

     

    Join.JPG

    Select Columns:

     

    Select Columns.JPG

     

    Let me know if you have questions.

Answers

  • user03357
    user03357 Member
    Answer ✓

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

     

    Full ETL:

    Full Flow.JPG

     

    Group by:

     

    Group By.JPG

    Join Data:

     

    Join.JPG

    Select Columns:

     

    Select Columns.JPG

     

    Let me know if you have questions.

  • user05925
    user05925 Member

    Thank you! This was exactly what I was looking for!

Categories