Icon

KNIME_​join_​unexpected_​rows

There is more than one lookup row forsome parents. "Unexpectedly" generates 21 rows whichis "correct" for the data supplied, but notwhat we wanted "Parent duplication removed"Creates 1 row for each invoice, so 15rows. Once we have established there isduplication, we need to manually inspectthe lookup data, and decide how it shouldbe fixed, or whether we need to changeour JOIN rules Correct join and data produces exactly 15rows from the join 15 INVOICESINVOICE PARENT LOOKUPJoin on Invoice NameLeft Outer JoinINVOICE PARENT LOOKUPWITH DUPLICATESJoin on Invoice NameLeft Outer Join15 INVOICESThis removes the duplicated parents,but we will need to go back and look at the data as we werenot expecting this duplicationJoin on Invoice NameLeft Outer Join Table Creator Table Creator Joiner Table Creator Joiner Table Creator DuplicateRow Filter Joiner There is more than one lookup row forsome parents. "Unexpectedly" generates 21 rows whichis "correct" for the data supplied, but notwhat we wanted "Parent duplication removed"Creates 1 row for each invoice, so 15rows. Once we have established there isduplication, we need to manually inspectthe lookup data, and decide how it shouldbe fixed, or whether we need to changeour JOIN rules Correct join and data produces exactly 15rows from the join 15 INVOICESINVOICE PARENT LOOKUPJoin on Invoice NameLeft Outer JoinINVOICE PARENT LOOKUPWITH DUPLICATESJoin on Invoice NameLeft Outer Join15 INVOICESThis removes the duplicated parents,but we will need to go back and look at the data as we werenot expecting this duplicationJoin on Invoice NameLeft Outer Join Table Creator Table Creator Joiner Table Creator Joiner Table Creator DuplicateRow Filter Joiner

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-05-06
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!