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
N/P: IIf(([DWQRYDATA_DCINVAUD]![NEW_QTY]-[DWQRYDATA_DCINVAUD]![OLD_QTY])*[DWMIRROR_IMASTER]![ICOSTP]>0,"P","N")
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.
CASE
WHEN `Change #`*`ICOSTP` > 0
THEN 'P'
ELSE 'N'
END
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!