Icon

Dubletten_​V2

Title

Desc

Approach:- Load all Attributes into one Column, - Filter duplicate values- Apply Algorithm (Provided by Ivan from KNIME Forum) to figure out the IDs with matching attributes. - Cluster the results that in the end there is a table looking like this: - Column 1: Attribute X - Clumn 2: ID with Attribute X - When there are duplicates, the attribute shall be listed a couple of times with each time a different ID in Column 2. Clustering the results. Failure because too many "Split Rows" occuring. Node 32Node 33Node 34Node 35Node 36Node 39Node 40Node 51Node 52Node 53Node 54Node 55Node 57Node 58Node 59Node 60Node 61Node 62Node 63Node 64Node 65Node 66Node 67Node 68Node 69Node 71Node 72Node 73Node 74Node 75Node 76Node 77Node 78Node 79Node 80 DuplicateRow Filter Cell Replacer GroupBy Cell Replacer RowID Split CollectionColumn Column Filter Column Filter Column Filter Column Filter Excel Reader Column Filter Column Rename Column Rename Column Rename Column Rename Concatenate Concatenate Concatenate DuplicateRow Filter Column Rename Column Rename Column Rename Column Rename Concatenate Column Filter Column Filter Column Filter Column Filter Concatenate Concatenate DuplicateRow Filter Sorter Row Filter Column Filter Approach:- Load all Attributes into one Column, - Filter duplicate values- Apply Algorithm (Provided by Ivan from KNIME Forum) to figure out the IDs with matching attributes. - Cluster the results that in the end there is a table looking like this: - Column 1: Attribute X - Clumn 2: ID with Attribute X - When there are duplicates, the attribute shall be listed a couple of times with each time a different ID in Column 2. Clustering the results. Failure because too many "Split Rows" occuring. Node 32Node 33Node 34Node 35Node 36Node 39Node 40Node 51Node 52Node 53Node 54Node 55Node 57Node 58Node 59Node 60Node 61Node 62Node 63Node 64Node 65Node 66Node 67Node 68Node 69Node 71Node 72Node 73Node 74Node 75Node 76Node 77Node 78Node 79Node 80 DuplicateRow Filter Cell Replacer GroupBy Cell Replacer RowID Split CollectionColumn Column Filter Column Filter Column Filter Column Filter Excel Reader Column Filter Column Rename Column Rename Column Rename Column Rename Concatenate Concatenate Concatenate DuplicateRow Filter Column Rename Column Rename Column Rename Column Rename Concatenate Column Filter Column Filter Column Filter Column Filter Concatenate Concatenate DuplicateRow Filter Sorter Row Filter Column Filter

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: Johnny
Created at: 2019-01-03
On NodePit since: 2022-02-06
Last update: 2024-04-26
Created with KNIME version: v4.3.2

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

Try NodePit Runner!