Split Numbers vs Strings

This workflow demonstates how to split number against string values from same column and place them in new ones. Main logic is contained in Rule Engine node where MATCHES operator is used to determine whether value is number (integer) or not. Operator is based on RegEx. Then pivoting node creates new collection columns holding either numbers or strings which are then ungrouped.

External resources

• Forum Topic