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!