Generate new row with specific condition

Hey guys

I want to create a new row from an exitsting row with the following conditions:

If value is equal to “-1” make new row and give value “1”

Else create value “0” in new row.

How do I do this?

If you data looks like Key, Value then use rule engine to replace old Value with new one
and use concatenate node to stack result with original data.

1 Like

Hi @stoffer88,

do you have one column or multiple columns? Do you need new row under the old one? From experience it is always best to give some example with (dummy) data.

Br,
Ivan

HI,

Use “Rule engine” node

&YourColumn& = -1 => 1
TRUE => 0

If you need a new column then select append column, if no then select replace column

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.