Global Formulas in ETLs
Options
jimsteph
Contributor
I would like to have a way to create complex formulas, save them (similar to the Beast Mode Manager) , and then have them available for use in ETLs; when an ETL that contains one of these formulas is executed the current version of the formula would always be used. This would have two use cases (for me):
- If there is a need to change the formula -- a change in business needs, error fixes, etc. -- it would only need to be changed in one place. Once changed, the updated formula would automatically be used in all ETLs that contain it. This would keep the formula from getting out of sync in the various ETLs that use it when we unknowingly skip one when trying to update them all.
- If there are multiple paths in an ETL -- for example, I'm trying to calculate member status for each of the past seven days, and this ends up having to be done in seven parallel paths -- changing the formula at the global level would change it in all paths.
Thanks!
Jim
4
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive