Icon

Similar Invoice Dates with classifier

calc min datefor each entrythat is considered aduplicatecalc max datefor each entrythat is considered aduplicatejoin together all invoices foreach vendorbased onvendor,amount,invoice numberstore rowid ascolumnrows going to topare "potentials" tokeep.Those going to bottom arewhere duplicates have been found the items on the the right of the lowerport list are the items to be removedfrom the TOP port listREMOVE "matched" rowsby keeping only the rowsthat don't appear in the right ofthe "matched" listremove duplicationresulting fromoriginal joinerPut backoriginal rowidon remainingrowsexecute to view spreadsheet in data folderNode 18distinguish unique from chosenchosenuniqueduplicateDate&Time Shift Date&Time Shift Joiner RowID Rule-basedRow Splitter Joiner DuplicateRow Filter RowID Open File or Folder Excel Reader Joiner ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Sorter calc min datefor each entrythat is considered aduplicatecalc max datefor each entrythat is considered aduplicatejoin together all invoices foreach vendorbased onvendor,amount,invoice numberstore rowid ascolumnrows going to topare "potentials" tokeep.Those going to bottom arewhere duplicates have been found the items on the the right of the lowerport list are the items to be removedfrom the TOP port listREMOVE "matched" rowsby keeping only the rowsthat don't appear in the right ofthe "matched" listremove duplicationresulting fromoriginal joinerPut backoriginal rowidon remainingrowsexecute to view spreadsheet in data folderNode 18distinguish unique from chosenchosenuniqueduplicateDate&Time Shift Date&Time Shift Joiner RowID Rule-basedRow Splitter Joiner DuplicateRow Filter RowID Open File or Folder Excel Reader Joiner ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Sorter

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: bbate
Created at: 2023-11-06
On NodePit since: 2023-11-07
Last update: 2024-04-27
Created with KNIME version: v4.7.7

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

Try NodePit Runner!