Icon

kn_​forum_​40032_​remove_​values_​keeping_​id

How to conditionally remove all values from row, leaving the empty row with original RowID?

How to conditionally remove all values from row, leaving the empty row with original RowID?


solution by https://forum.knime.com/u/bruno29ahttps://forum.knime.com/t/how-to-conditionally-remove-all-values-from-row-leaving-the-empty-row-with-original-rowid/40032/3?u=mlauber71 How to conditionally remove all values from row, leaving the empty row with original RowID? Node 1Node 2Node 3Node 4$Valid$ = "TRUE" => TRUETRUE => FALSE^(RowID|Valid|Counter)$sort by Counterexclude exitsing RowIDCounteras RowIDCounteras RowID^(RowID|Valid|Counter)$sort by Counter$Valid$ = "TRUE" => TRUETRUE => FALSEreturn $$ROWINDEX$$; Table Creator Rule Engine Math Formula(Multi Column) Column Filter Rule-basedRow Splitter Column Filter Concatenate Sorter Counter Generation Column Filter RowID RowID Column Filter Sorter Concatenate Rule-basedRow Splitter Java Snippet(simple) solution by https://forum.knime.com/u/bruno29ahttps://forum.knime.com/t/how-to-conditionally-remove-all-values-from-row-leaving-the-empty-row-with-original-rowid/40032/3?u=mlauber71 How to conditionally remove all values from row, leaving the empty row with original RowID? Node 1Node 2Node 3Node 4$Valid$ = "TRUE" => TRUETRUE => FALSE^(RowID|Valid|Counter)$sort by Counterexclude exitsing RowIDCounteras RowIDCounteras RowID^(RowID|Valid|Counter)$sort by Counter$Valid$ = "TRUE" => TRUETRUE => FALSEreturn $$ROWINDEX$$; Table Creator Rule Engine Math Formula(Multi Column) Column Filter Rule-basedRow Splitter Column Filter Concatenate Sorter Counter Generation Column Filter RowID RowID Column Filter Sorter Concatenate Rule-basedRow Splitter Java Snippet(simple)

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: bruno
Created at: 2022-02-20
On NodePit since: 2022-02-22
Last update: 2024-04-26
Created with KNIME version: v4.5.1
Tags: missingconcatenatefilterrow

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

Try NodePit Runner!