Icon

A fun little puzzle for the weekend - Party Animals version

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" equates to "A", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" equates to "B", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" equates to "C", then change all "W" in theabove columns into a single space. If for this row, the column named "selected" equates to" 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" equates to "A", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" equates to"B", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" equates to"C", then change all "o" in the abovecolumns into a single space. If for this row, the column named "selected" equates to "D", then change all "W" in theabove columns 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 Definition of "equates to"...In this version the "selected" column doesn't contain A,B,C or D.It contains a type of animal/creature. I use the term "animal"below which basically means any creature.All begin with the letter A. All names are in "Title" case, so everyword begins with a capital, and all other letters are lower case.If the type of animal is (using string comparison rules) less thanthe string "African Grey", then it equates to "A"If the type of animal does not equate to A, but (using stringcomparison rules) less than the string "American", then it equatesto "B"If the type of animal does not equate to A or B, but (using stringcomparison rules) less than the string "Archer", then it equates to"C"If the type of animal does not equate to A, B or C then it equatesto "D"...It may still be possible using similar solutions to before, which isof course acceptable, if it works, but can you find an alternativeway?You may include the "cutoff" strings "African Grey", "American"and "Archer" in your solution, but you may not hardcode the fullname of any creature! Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 70Node 75Node 76Node 89 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 Column Expressions Table Creator Cell Replacer String Manipulation(Multi Column) 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" equates to "A", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" equates to "B", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" equates to "C", then change all "W" in theabove columns into a single space. If for this row, the column named "selected" equates to" 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" equates to "A", then change all "t" in the abovecolumns into a single space. If for this row, the column named "selected" equates to"B", then change all "e" in the abovecolumns into a single space.If for this row, the column named "selected" equates to"C", then change all "o" in the abovecolumns into a single space. If for this row, the column named "selected" equates to "D", then change all "W" in theabove columns 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 Definition of "equates to"...In this version the "selected" column doesn't contain A,B,C or D.It contains a type of animal/creature. I use the term "animal"below which basically means any creature.All begin with the letter A. All names are in "Title" case, so everyword begins with a capital, and all other letters are lower case.If the type of animal is (using string comparison rules) less thanthe string "African Grey", then it equates to "A"If the type of animal does not equate to A, but (using stringcomparison rules) less than the string "American", then it equatesto "B"If the type of animal does not equate to A or B, but (using stringcomparison rules) less than the string "Archer", then it equates to"C"If the type of animal does not equate to A, B or C then it equatesto "D"...It may still be possible using similar solutions to before, which isof course acceptable, if it works, but can you find an alternativeway?You may include the "cutoff" strings "African Grey", "American"and "Archer" in your solution, but you may not hardcode the fullname of any creature! Data from a fileNode 45Node 47Node 49Node 50Node 51Node 52Node 53Node 54Pure poetry! ;-)Node 58Node 59Node 60Node 61Node 63Node 64Node 65Node 66Node 70Node 75Node 76Node 89CSV 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 Column Expressions Table Creator Cell Replacer 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-11-24
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!