Magic ETL - Group By Tile - Sum Multiple Integer Columns

Hi all,

I have a Magic ETL flow going currently where I have three input datasets that I am appending into one dataset. All three datasets have the similar fields and columns, but one of the datasets I need to manually SUM three individual columns across each row to get the "Total" count that exists in the other two datasets as just a single column/field.

• Input Dataset 1: Name |Spend | Inside Leads| Outside Leads | Phone Leads
• Input Dataset 2: Name | Spend |Total Leads
• Input Dataset 3: Name | Cost |Total Leads

• Input Dataset 1 Flow: Input Source -> Select Columns -> Group By -> Add Constant -> Append -> Output Dataset
• Input Dataset 2 Flow: Input Source -> Select Columns -> Add Constant -> Append -> Output Dataset
• Input Dataset 2 Flow: Input Source -> Select Columns -> Add Constant -> Append -> Output Dataset

Output Dataset: Name | Cost | Total Leads

Step 3 "Group by" in my Input Dataset 1 Flow below seems to be where my issue is. If I pull the three individual integer columns into the output dataset, I can aggregate them together just fine with the Step 3 formula below through Beast Mode into a table/chart, but ideally I want the dataset to be fully aligned and pre-aggregated so I dont have an output like the one below:

Output Dataset (do not want): Name | Cost | Total Leads | Phone | Inside | Outside

Any insight is appreciated! Thanks!