(Multi Column) version of Rule & Column Expression

[iCFO]

It would be great to have a multi-column version of these nodes. There are a ton of multi column tasks that are missing or less intuitive in the Math and Sting nodes which would be simplified quite a bit with these new additions. I would love to be able to generally leverage the multi tool capabilities of the Rule Engine / Column Expressions nodes on multiple columns at once.

For example: You could change 50 binary columns into Boolean in a few seconds with a Multi Column Rule Engine.

[sanket_2012]

Hi @iCFO ,
Thanks for your suggestion.
A ticket exists to explore the multi-tool capabilities of the Column expression node.
We will keep you updated regarding this.

Thanks,
Sanket

[gonhaddock]

Hello
Here there is a forum topic illustrating a use case, when ‘Rule Engine (Multi Column)’ could handle a task in a single node:

Missing value node does not replace ? sign

Hello @clos You can test the following code into a ‘Rule Engine’ node: $native-country$ MATCHES "^(?!\?$).*$" => $native-country$ As a the Rule Engine node works on a single column basis. You may want to deploy it in a column loop. Otherwise you will end up with a 15 Rule Engine nodes workflow, as the number of columns in your sample file. BR

Voted +1 from my side.

BR

[iCFO]

One that I would use weekly would be to use Regex to remove any non numeric characters from all “number” columns to clean up sloppy manual entry in cells. Things like “$1,500 (estimate)” or “TBD” or “10000 - see breakdown to right”. I may also need to round them and then convert them to another number type like integer.

I currently get around this with the String Multi node, but have to use a flow variable column test / selection process since it fails when a column is not String type. This become trickier in a loop involving pivots and heavy transformations… Column Expression or Rule Engine could better handle variations in the column input types.