Icon

Identifying columns containing Character using UnPivot and Rule Engine

Identifying columns containing Character using UnPivot and Rule Engine with Group By

Demonstrates use of the unpivoting to identify those columns that contain a "!" character, and return these as a comma separated list on each row

Columns to inspectfind the rows containing "!"concatenate theflagged column namesNode 12Table Creator Unpivoting Rule Engine GroupBy Joiner Columns to inspectfind the rows containing "!"concatenate theflagged column namesNode 12Table Creator Unpivoting Rule Engine GroupBy Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2025-10-02
On NodePit since: 2025-10-03
Last update: 2025-10-03
Created with KNIME version: v4.7.8

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!