Icon

Duplicate INV No

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

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

Check: Which rule appliesGenerate Overview of fuzzy duplicates Identification of fuzzy duplicatesSimilar criteria:1. Same invoice number with new letter (e.g. 582789 and 582789a) -> 1 letter difference.2. Same invoice number starting with dot (e.g. .12567 and 12567) -> 1 character difference.3. Same invoice number starting with 0 (e.g. 058299 and 58299) -> 1 number difference (starting with 0; rest the same).Include all duplicates:First ExpressionSecond ExpressionThird ExpressionGroup by of all duplicates(Overview)Exclude invoices with same counterCounterunique sequenceJoin columnsfor counter and INV AMTInner Join for:- Vendor ID-INV AMT- INV DateHerewith the invoices becomecomparableExcel file Column Expressions Rule-basedRow Filter GroupBy Rule-basedRow Filter Counter Generation Joiner Excel Reader Check: Which rule appliesGenerate Overview of fuzzy duplicates Identification of fuzzy duplicatesSimilar criteria:1. Same invoice number with new letter (e.g. 582789 and 582789a) -> 1 letter difference.2. Same invoice number starting with dot (e.g. .12567 and 12567) -> 1 character difference.3. Same invoice number starting with 0 (e.g. 058299 and 58299) -> 1 number difference (starting with 0; rest the same).Include all duplicates:First ExpressionSecond ExpressionThird ExpressionGroup by of all duplicates(Overview)Exclude invoices with same counterCounterunique sequenceJoin columnsfor counter and INV AMTInner Join for:- Vendor ID-INV AMT- INV DateHerewith the invoices becomecomparableExcel file Column Expressions Rule-basedRow Filter GroupBy Rule-basedRow Filter Counter Generation Joiner Excel Reader

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: causevia
Created at: 2023-11-10
On NodePit since: 2023-11-10
Last update: 2024-04-27
Created with KNIME version: v5.1.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!