Total Spend per Customer from a JSON Export

Import a flat JSON order export and append each customer’s total spend to every matching order row. Retain the original columns, preserve source lineage, and reuse the structured transform across runs.

About this Model

Adds a per-customer aggregate to each row of an uploaded flat JSON order export. The default result retains order_id, customer, and amount, and appends customer_total as the sum of amount across rows sharing the same customer. A change request can update the same transform to count orders per customer instead. Repeated runs reuse the existing transform, while reset removes generated results without removing the source JSON or its imported table.

• Imports flat order objects from orders.json as a table
• Creates one structured Customer Totals transform
• Retains order_id, customer, and amount on every row
• Appends customer_total grouped by customer
• Can change the aggregate from spend sum to order count
• Supports clean reset and repeatable runs without duplicate transforms

Products Used

Tools Used