if column A is missing or 0, Column B value will replace as 0

[newba]

Book1.xlsx (10.5 KB)

What I need is, if “Score from Clients” equals to 0 or Missing, “Score from Internal customer” will also return into 0.
And if “Score from Internal customer” is 0 or Missing, “Score from Clients” also return to 0 as well.
I do not want to use row filter as I still need to keep all the information from other columns.

My ideal result

I tried to used “Rule engine”. But it cannot allow me to replace the other column’s value.

Hope someone can help me on this. Thank you so much.

[ipazin]

Hello @newba,

in Rule Engine (and other similar nodes like Math Formula, String Manipulation…) you determine to which column output applies with bottom options Append Column or Replace Column. After “=>” sign you only need value.

Br,
Ivan

[newba]

OMG this is so simple why didn’t I think of that!
Thank you so much!

[hmfa]

Hi @newba

If I understood your need you will have to use two expression nodes in sequence

One to replace “Score from internal costumer”
Use this expression.

MISSING $Score From Clients$ OR $Score From Clients$=0=>0

Use Replace column $Score from internal costumer$

Another node to replace “Score From Cients”
Use this expression.

MISSING $Score from internal costumers$ OR $Score from internal Clients$=0=>0

Use Replace column $Score From Clients$

Is this correct?
Br