Icon

Sum duplicates

This workflow sums the "code" values for each occurrence of aparticular amount.It then zeroes the total if the code and the sum of the codes areequal, as this identifies that the sum has not appeared twice This workflow sums the "code" values for each occurrence of aparticular amount.It then zeroes the total if the count of a code = 1 as this identifiesthat the sum has not appeared twice.This would be needed if a code could be zero or possibly negativeresulting in multiple codes cancelling each other out andpreventing the first method from working Sample datacode, amountSum "code" group by "amount"Join back by amountrename to "dup"Non-duplicated to zeroand zero-amounts to zeroJoin back by amountSum "code" and Count "code"group by "amount"Non-duplicated to zeroand zero-amounts to zerorename to "dup"Sample datacode, amountremove additional "count" column Table Creator GroupBy Joiner Column Rename Rule Engine Joiner GroupBy Rule Engine Column Rename Table Creator Column Filter This workflow sums the "code" values for each occurrence of aparticular amount.It then zeroes the total if the code and the sum of the codes areequal, as this identifies that the sum has not appeared twice This workflow sums the "code" values for each occurrence of aparticular amount.It then zeroes the total if the count of a code = 1 as this identifiesthat the sum has not appeared twice.This would be needed if a code could be zero or possibly negativeresulting in multiple codes cancelling each other out andpreventing the first method from working Sample datacode, amountSum "code" group by "amount"Join back by amountrename to "dup"Non-duplicated to zeroand zero-amounts to zeroJoin back by amountSum "code" and Count "code"group by "amount"Non-duplicated to zeroand zero-amounts to zerorename to "dup"Sample datacode, amountremove additional "count" column Table Creator GroupBy Joiner Column Rename Rule Engine Joiner GroupBy Rule Engine Column Rename Table Creator 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: @takbb Brian Bates
Created at: 2021-07-01
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.3.3

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

Try NodePit Runner!