ETL - adding a field based off a Case Statement Help
Currently we have an Access Query that has an expression created to add a field with a value to our data. Below is the expression written in MS Access
I need to add the same function to the ETL for my report I am moving over to Domo. However I am not seeing where you can add this type of add field fucntion in the ETL setup.
This is what I wrote for a beast mode I tested however I need this field to be embeded into the table so it can be run with other ETL's off this data.
WHEN `Change #`*`ICOSTP` > 0
Can I create this type of function in an actual ETL? Or do I need to do this via SQL (I am horrible at SQL). I hope this can be done via ETL.
Any ideas or help is greatly appreciated!
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部