Icon

kn_​forum_​39825_​duplicate_​removal_​pairs

Identify pairs of payments and eliminate remaining duplicates from a transaction list

Identify pairs of payments and eliminate remaining duplicates from a transaction list


Identify pairs of payments and eliminate remaining duplicates from a transaction list second idea is to find a matching transaction to every debt (negative values). The first transaction matching the debt in Name, City, Country and abs(Value) is used and then elminiated from the poolhttps://forum.knime.com/t/duplicates-removal/39825/13?u=mlauber71 Knime example11 .xlsx$Description$ = "Debt" => TRUETRUE => FALSE$Value$ *-1(convert to Integer)match byName, City, Country and abs(Debt)Transaction ID - DebtTransaction ID - PaidExcludeTransactions Debt and PaidExcludeTransactions Debt and Paidfilter the remainingtransactionsto eleminate dupliactes$duplicate-type-classifier$ = "unique" => TRUE$duplicate-type-classifier$ = "chosen" => TRUETRUE => FALSEDateKnime example12 .xlsx$Value$ *-1(convert to Integer)$Value_abs$ < 0 => $Value$TRUE => $Value_abs$$Value$ >= 0 => TRUETRUE => FALSETransaction IDSTARTfilerone DebtNode 24choose one transaction$Date_Paid$ >= $Date$ => TRUETRUE => FALSE=> make sure date paid issame or later as debt$Counter$ = 1 => TRUETransaction IDSTOPNode 33Transaction ID DebtTransaction ID DebtTransaction ID PaidNode 37_tmp_paid.table_tmp_paid.tableget the remaining poolof debtsDate_Paid_tmp_paid.tablesave the remaining poolof debtsresult_12.xlsxresult Excel Reader Rule-basedRow Splitter Math Formula Joiner Java Snippet(simple) Java Snippet(simple) ReferenceRow Filter ReferenceRow Filter DuplicateRow Filter Sorter Rule-basedRow Filter Color Manager String to Date&Time Excel Reader Math Formula Rule Engine Rule-basedRow Splitter Table Row ToVariable Loop Start Row Filter Joiner Sorter Rule-basedRow Filter Counter Generation Rule-basedRow Filter Column Filter Loop End Joiner Joiner Column Rename Rule Engine Rule Engine Column Resorter Table Writer Table Reader Column Rename ReferenceRow Filter Table Writer RowID Excel Writer Rule Engine Color Manager Identify pairs of payments and eliminate remaining duplicates from a transaction list second idea is to find a matching transaction to every debt (negative values). The first transaction matching the debt in Name, City, Country and abs(Value) is used and then elminiated from the poolhttps://forum.knime.com/t/duplicates-removal/39825/13?u=mlauber71 Knime example11 .xlsx$Description$ = "Debt" => TRUETRUE => FALSE$Value$ *-1(convert to Integer)match byName, City, Country and abs(Debt)Transaction ID - DebtTransaction ID - PaidExcludeTransactions Debt and PaidExcludeTransactions Debt and Paidfilter the remainingtransactionsto eleminate dupliactes$duplicate-type-classifier$ = "unique" => TRUE$duplicate-type-classifier$ = "chosen" => TRUETRUE => FALSEDateKnime example12 .xlsx$Value$ *-1(convert to Integer)$Value_abs$ < 0 => $Value$TRUE => $Value_abs$$Value$ >= 0 => TRUETRUE => FALSETransaction IDSTARTfilerone DebtNode 24choose one transaction$Date_Paid$ >= $Date$ => TRUETRUE => FALSE=> make sure date paid issame or later as debt$Counter$ = 1 => TRUETransaction IDSTOPNode 33Transaction ID DebtTransaction ID DebtTransaction ID PaidNode 37_tmp_paid.table_tmp_paid.tableget the remaining poolof debtsDate_Paid_tmp_paid.tablesave the remaining poolof debtsresult_12.xlsxresultExcel Reader Rule-basedRow Splitter Math Formula Joiner Java Snippet(simple) Java Snippet(simple) ReferenceRow Filter ReferenceRow Filter DuplicateRow Filter Sorter Rule-basedRow Filter Color Manager String to Date&Time Excel Reader Math Formula Rule Engine Rule-basedRow Splitter Table Row ToVariable Loop Start Row Filter Joiner Sorter Rule-basedRow Filter Counter Generation Rule-basedRow Filter Column Filter Loop End Joiner Joiner Column Rename Rule Engine Rule Engine Column Resorter Table Writer Table Reader Column Rename ReferenceRow Filter Table Writer RowID Excel Writer Rule Engine Color Manager

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: m_lauber
Created at: 2022-02-18
On NodePit since: 2022-02-19
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: duplicatesremoval

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

Try NodePit Runner!