Icon

A fun little puzzle for the weekend - made harder-1

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 Now for what is (I hope!) a slightly harder challenge. (Almost) the same flow as before butthe data has changed, and so have the rules.As before, you are to use just one node...This node is to process the values in the following columns Q B C M N W V X Zand apply the rules belowRULES (Made Harder...maybe!):If for this row, the column named "selected" contains "A", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" contains "B", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" contains "C", then change all "W" in the abovecolumns into a single space. If for this row, the column named "selected" contains "D", then change all "o" 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... Samepoem as before... but if you don't it will stay slightly (or a lot) garbled depending on what youdid.enjoy! Link yournode here Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 57Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 67 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 GroupBy 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 Now for what is (I hope!) a slightly harder challenge. (Almost) the same flow as before butthe data has changed, and so have the rules.As before, you are to use just one node...This node is to process the values in the following columns Q B C M N W V X Zand apply the rules belowRULES (Made Harder...maybe!):If for this row, the column named "selected" contains "A", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" contains "B", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" contains "C", then change all "W" in the abovecolumns into a single space. If for this row, the column named "selected" contains "D", then change all "o" 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... Samepoem as before... but if you don't it will stay slightly (or a lot) garbled depending on what youdid.enjoy! Link yournode here Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 57Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 67CSV 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 GroupBy 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.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!