How to write this formula in datiku?

prash_
prash_ Registered Posts: 17 ✭

IF [ASIA]=0 THEN "CERO"
ELSEIF [ASIA]<=1 THEN
IF [ASIA]>=-1 THEN "DENTRLRANCIA"
ELSEIF [ASIA]>0 THEN "DIFERETIVA"
ELSE "DIFERENTIVA" ENDIF
ELSEIF [TOTAL]=0 THEN "DIOT"
ELSEIF [TOTTABLE]=0 THEN "CONTABLE"
ELSEIF [ASIA]>0 THEN "DIFER POSI"
ELSE "DIFERNEGVA" ENDIF

Best Answer

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,728 Neuron
    Answer ✓

    It depends. Where you need it? Python Recipe, Prepare Recipe Formula, etc. Also your code doesn't have any tabulation so it's imposible to understand the else/elseif clauses.

Answers

  • prash_
    prash_ Registered Posts: 17 ✭

    can you provide any such query in prepare recipe?

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,728 Neuron

    I can but you need to paste a properly formated code sample. Use the code button to insert the code in a properly formatted way.

Setup Info
    Tags
      Help me…