Icon

A fun little puzzle for the weekend - ODDly made EVEN harder (regex dictionary)

Insert a SINGLE node here, which mustNOT be any of the following:Column ExpressionJava of any sortPython of any sortR of any sortPreviously I said you couldn't use Column Expression (multi column)lol... of course that's primarily becausethere is no such node... ;-)but even if you quickly write one, you stillaren't allowed to use it!Oh yes... and No Components orMetaNodes either! lol The DATA has changed slightly again, and the rules got slightly tougher...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 EVEN Harder...maybe!):The following rules apply when the value of "seq" is EVENIf 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. The following rules apply when the value of "seq" is ODDIf for this row, the column named "selected" contains "B", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" contains "A", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" contains "D", then change all "W" in the abovecolumns into a single space. If for this row, the column named "selected" contains "C", 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 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 67Node 70 CSV Reader Column Resorter Column Resorter Sorter Ungroup Column Aggregator Column Filter Transpose Column Aggregator Column Rename String To Number Number To String CASE SwitchData (Start) Table Rowto Variable Column Rename CASE SwitchData (End) Column Rename GroupBy String Manipulation(Multi Column) Column Expressions Insert a SINGLE node here, which mustNOT be any of the following:Column ExpressionJava of any sortPython of any sortR of any sortPreviously I said you couldn't use Column Expression (multi column)lol... of course that's primarily becausethere is no such node... ;-)but even if you quickly write one, you stillaren't allowed to use it!Oh yes... and No Components orMetaNodes either! lol The DATA has changed slightly again, and the rules got slightly tougher...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 EVEN Harder...maybe!):The following rules apply when the value of "seq" is EVENIf 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. The following rules apply when the value of "seq" is ODDIf for this row, the column named "selected" contains "B", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" contains "A", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" contains "D", then change all "W" in the abovecolumns into a single space. If for this row, the column named "selected" contains "C", 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 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 67Node 70CSV Reader Column Resorter Column Resorter Sorter Ungroup Column Aggregator Column Filter Transpose Column Aggregator Column Rename String To Number Number To String CASE SwitchData (Start) Table Rowto Variable Column Rename CASE SwitchData (End) Column Rename GroupBy String Manipulation(Multi Column) Column Expressions

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-11-04
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!