Hi Thank you.
could you pls help me with this problem?
In a column we have some cells equal to zero, and we want replace them with values that are in an other column.
for example,
we want replace column Ship to Code zero with Sold To Code:
above rules from @ScottF mean following:
If value in column “Ship to Code” is zero take value from column “Sold to Code”. In any other case take value from column “Ship to Code”.
What might help your understanding is that “The first matching rule in order of definition determines the outcome.”
not sure I understand. Your rules are ok. Second row of Ship to Code is a big number but column is String. Maybe String to Number node can help but how did you end up with String column? How does you workflow looks like?
just to share where String type column comes from. Your “Sold to Code” column is String and in Rule Engine “the type of the outcome column is the common super type of all possible outcomes”. That explains it.