Can Magic ETL calculate a sum over an entire column?
I hope I am missing something here.
I want to simply run the equivalent of SELECT SUM(columnA) from TableB in Magic ETL. However, it seems the only way to do this sum is: 1) add a columnC to TableB where every row in columnC is the same value, and 2) do a Group By aggregating on columnC.
Is there a better way in Magic ETL?
Best Answer
-
Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns tile.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns tile.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thanks for confirming, @MarkSnodgrass
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive