Icon

20210927 Pikairos Search unknown word in different columns

2021 Pikairos Search unknown word in different columns

There has been no description set for this workflow's metadata.

Your DataAggregateColumnsCreate Bit VectorFrom Aggregated ColumnsExpand Bit VectorThe result here is without Counts!ConcatenateColour columnsper row with CountSplit concatenantedcolumn andcreate a listwith itUngroupthe listRemove uselesscharacters andconvert countinto integerSplit every colourfrom its countand generate2 new columnsFilter uselesscolumnsUnpivotColours with Countsso that you getone column per colourwith its counts on rowCreate a RowIDcolumn forlater useby PivotingConvert Colour CountMissing Valuesinto 0Join with originalTable basedon RowIDTable Creator Column Aggregator Create Bit Vector Expand Bit Vector Column Aggregator Cell Splitter Ungroup String Manipulation Cell Splitter Column Filter Pivoting RowID Missing Value Joiner Your DataAggregateColumnsCreate Bit VectorFrom Aggregated ColumnsExpand Bit VectorThe result here is without Counts!ConcatenateColour columnsper row with CountSplit concatenantedcolumn andcreate a listwith itUngroupthe listRemove uselesscharacters andconvert countinto integerSplit every colourfrom its countand generate2 new columnsFilter uselesscolumnsUnpivotColours with Countsso that you getone column per colourwith its counts on rowCreate a RowIDcolumn forlater useby PivotingConvert Colour CountMissing Valuesinto 0Join with originalTable basedon RowIDTable Creator Column Aggregator Create Bit Vector Expand Bit Vector Column Aggregator Cell Splitter Ungroup String Manipulation Cell Splitter Column Filter Pivoting RowID Missing Value Joiner

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: Molina
Created at: 2021-09-27
On NodePit since: 2022-02-06
Last update: 2024-11-24
Created with KNIME version: v4.4.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!