Hi @UGChris , As @elsamuel said, the column expressions node appears to be the way to go. I’m having a little difficulty deciding what of your requirement is actually the objective, and which parts of it are just based on your “implementation” of it. For example, is producing “Score” and “Score 2” just your mechanism for determining an overall total, or do you actually need to record both scores?

I’m assuming for the moment that having a pair of scores is mere implementation and not the objective, but I may of course be wrong.

The example that @elsamuel gave was based on it being mutually exclusive, but if you say they are not then you can still do that with a single column expression.

Taking a table from one of your original workflows

You can join that to a Column Expressions node

And then within the column expressions node, it’s note immediately obvious, but you can write quite complex logic:

```
// example of running sequence of conditions that aren't mutually exclusive
// to form a running total in "calc_score" variable that is then returned at
// the end to populate the Score column
var calc_score=0
if (column("number")> 5)
{calc_score += 2} // or shorthand for calc_score = calc_score+2
if (column("number")> 8)
{calc_score += 2} // or shorthand for calc_score = calc_score+2
calc_score // this is the returned value from the above logic
```

You can include variables as well, so if you want to run a sequence of IF conditions against the “number” column which aren’t mutually exclusive, you can have a variable such as “calc_score” (which is just internal to the node), and in this case if the number is greater than 5, it will add 2 to the score, and if that same number is greater than 8 it will add a further 2 to it. The value of calc_score will then be returned into the column specified at the top of the node’s config dialog.

For your table, the result of the above is as follows:

So do you need “Score_2”?

Incidentally, you can also put separate expressions in for different columns within the same Column Expressions node, although there isn’t a multi-column version so if you wanted to execute the same expressions against multiple columns you either have to repeat for each column or you have to put the node into a table column loop.

Attached is the example column expression above

Column Expressions example.knwf (7.2 KB)