Icon

QA-unapproved-users

Option 1 - de-duplicate each table, then concatenate the tables andfilter out any duplications from concatenation.For concatenation, we need to make sure both tables have samecolumn names, so I have renamed column on one of the input tables to match the other Option 2 - use Joiner (Labs)which can outputs mismatchesto separate ports All DataAll DataApproved listApproved ListExecute this nodeto "open" Workflow Data folderin ExplorerPlace one tablebelow the other as one single tableRemove duplicationsin original tableRemove duplications in original tableRename to "List"Mark Duplicatesbut keepRemove additionalcolumnsOutputs:Top -->in bothMiddle --> Only in All DataBottom --> Only in Approved ListWrite Unapproved listUnapproved UsersIndicate Table NameIndicate Table NameKeep only thosethat were markedas "unique" and was from "All Data" Open File or Folder Excel Reader Excel Reader Open File or Folder Open File or Folder Concatenate DuplicateRow Filter DuplicateRow Filter Column Rename DuplicateRow Filter Column Filter Joiner (Labs) Excel Writer Open File or Folder ConstantValue Column ConstantValue Column Rule-basedRow Filter Option 1 - de-duplicate each table, then concatenate the tables andfilter out any duplications from concatenation.For concatenation, we need to make sure both tables have samecolumn names, so I have renamed column on one of the input tables to match the other Option 2 - use Joiner (Labs)which can outputs mismatchesto separate ports All DataAll DataApproved listApproved ListExecute this nodeto "open" Workflow Data folderin ExplorerPlace one tablebelow the other as one single tableRemove duplicationsin original tableRemove duplications in original tableRename to "List"Mark Duplicatesbut keepRemove additionalcolumnsOutputs:Top -->in bothMiddle --> Only in All DataBottom --> Only in Approved ListWrite Unapproved listUnapproved UsersIndicate Table NameIndicate Table NameKeep only thosethat were markedas "unique" and was from "All Data"Open File or Folder Excel Reader Excel Reader Open File or Folder Open File or Folder Concatenate DuplicateRow Filter DuplicateRow Filter Column Rename DuplicateRow Filter Column Filter Joiner (Labs) Excel Writer Open File or Folder ConstantValue Column ConstantValue Column Rule-basedRow 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: mitin.sv
Created at: 2021-05-18
On NodePit since: 2022-02-06
Last update: 2024-04-27
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!