Icon

A fun little puzzle for the weekend - Bruno

Insert a SINGLE node here, which mustNOT be any of the following:Column ExpressionColumn Expression (multi column)Java of any sortPython of any sortR of any sort This node is to process the values in the following columns Q B C M N W V X Zand apply the rules belowRULES:If for this row, the column named "selected" contains "Y", then change all "z" in the abovecolumns into a single space.If for this row, the column named "selected" contains "N", then change all "q" in the abovecolumns into a single space. But remember, you are allowed to use only ONE nodeand it must NOT be any of the "programming" or "scripting" nodes listed on the left.If you succeed, then the output on the right will be your reward... a piece of poetry... enjoy! Link yournode here Bruno's comment:Looking at the data, the columns have "z" only for when "selected" has"Y", and the columns have "q" only for when "selected" has "N".Based on this, it means I do not need to rely on "selected", herebyremoving the need to do if, and can do replace of "z" or "q" into singlespace Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 57Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66 CSV Reader Column Resorter Column Resorter Sorter Ungroup Column Aggregator Column Filter Transpose Column Aggregator Column Rename Rule Engine String To Number Number To String CASE SwitchData (Start) Table Rowto Variable Column Rename CASE SwitchData (End) Column Rename String Manipulation(Multi Column) Insert a SINGLE node here, which mustNOT be any of the following:Column ExpressionColumn Expression (multi column)Java of any sortPython of any sortR of any sort This node is to process the values in the following columns Q B C M N W V X Zand apply the rules belowRULES:If for this row, the column named "selected" contains "Y", then change all "z" in the abovecolumns into a single space.If for this row, the column named "selected" contains "N", then change all "q" in the abovecolumns into a single space. But remember, you are allowed to use only ONE nodeand it must NOT be any of the "programming" or "scripting" nodes listed on the left.If you succeed, then the output on the right will be your reward... a piece of poetry... enjoy! Link yournode here Bruno's comment:Looking at the data, the columns have "z" only for when "selected" has"Y", and the columns have "q" only for when "selected" has "N".Based on this, it means I do not need to rely on "selected", herebyremoving the need to do if, and can do replace of "z" or "q" into singlespace Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 57Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66CSV Reader Column Resorter Column Resorter Sorter Ungroup Column Aggregator Column Filter Transpose Column Aggregator Column Rename Rule Engine String To Number Number To String CASE SwitchData (Start) Table Rowto Variable Column Rename CASE SwitchData (End) Column Rename String Manipulation(Multi Column)

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: @takbb Brian Bates
Created at: 2021-06-19
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.3

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

Try NodePit Runner!