Icon

Filtering Cells containing String

This workflow shows how using Unpivoting and Pivoting allows us to filter all cells in a certain table. In this example, we only want to keep cells that contain a string from a provided list.

Sample dataFlatten tableReference dataLIKE *<value>*Apply rulesBack to original shapeTable Creator Unpivoting Table Creator String Manipulation Rule-based RowFilter (Dictionary) Pivoting Sample dataFlatten tableReference dataLIKE *<value>*Apply rulesBack to original shapeTable Creator Unpivoting Table Creator String Manipulation Rule-based RowFilter (Dictionary) Pivoting

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: alexander
Created at: 2023-04-06
On NodePit since: 2023-04-06
Last update: 2024-04-30
Created with KNIME version: v4.7.1

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

Try NodePit Runner!