formula
David_Mellamphy
Registered Posts: 9 ✭
Hi I want to add a prepare recipe / formula to add column 1 + column 2 values, then subtract column 4 and 5, and give me the answer in another column, I know that in this example the results will be zero however I will have results where there will be differences.
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,212 Dataiker
Hi @David_Mellamphy
,In a prepare recipe processor https://doc.dataiku.com/dss/latest/preparation/processors/formula.html
formula syntax https://doc.dataiku.com/dss/latest/formula/index.html
Something like this, if I understand correctly :
(numval("column 1")+ numval("column 1")) - (numval("column 4")+ numval("column 5"))