We’ve released an update to the Insert If/Else Column step. This transform inserts a new column, and then fills it with values based on rules that you set up.
Set up as many rules as you need, each inserting a different value. Each rule can also be set up to use any number of conditions.
When using multiple rules, the step will find the first rule that matches for each row, and use that to fill in the value. If no rules match, then the final default value is used.
With this update, the values that any rule inserts into the new column can include a column merge tag, allowing you to reference the value of another column in this new column.
We’ve also updated how the step looks to make it easier to understand and read.