Icon

Joiner within a specific time frame

Tries to match all order id linesregardless of sequence, and then filtersout based on time window, and marksquantity mismatches Tries to match all order id lines using bothorder id and row sequence, marks rowsbased on time window, and marksquantity mismatches.Assumes that all rows in Table 2 will beexactly same sequence as Table 1 Tries to match all order id lines using bothorder id and a ranking within order_id /order_number, marks rows based ontime window, and marksquantity mismatches.Assumes that all rows *for any givenorder* in Table 2 will be in samesequence as Table 1 Tries to match all order id lines using both order idand a ranking within order_id / order_number,marks rows based on time window, and marksquantity mismatches.Assumes that rows might appear in any order, butthat they should be compared in order of datetime for any given order Table 2 will be in samesequence as Table 1 Table 1 (A)Table 2 (B)Join on order idUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Calc 2 hour windowfrom table1 transaction timeRemove thosematched order numbers that aren't within windowFlagQty MismatchTable 2 (B)Use a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Join on order idand row counterFlagQty MismatchTable 1 (A)Calc 2 hour windowfrom table1 transaction timerow counterrow counterJoin on order idand rankingTable 1 (A)Table 2 (B)Calc 2 hour windowfrom table1 transaction timeUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]FlagQty MismatchTable 1 (A)Table 2 (B)Use a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Find those " outside window"Join on order idand rankingFlagQty MismatchCalc 2 hour windowfrom table1 transaction timerank in order of Order Number and Transaction Daterank in order of Order ID and PERFORMED_DATEUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Mix up the rowsMix up the rowsrow counterrow counterRank each orderline in sequenceRank each orderline in sequencesort byorder numberand txn date/time(as we shuffled at beginning)Find those " outside window"Find those " outside window"Find those " outside window" Table Creator Table Creator Joiner String to Date&Time Date&Time Shift Row Filter Rule Engine Table Creator String to Date&Time Joiner Rule Engine Table Creator Date&Time Shift Counter Generation Counter Generation Joiner Table Creator Table Creator Date&Time Shift String to Date&Time Rule Engine Table Creator Table Creator String to Date&Time Rule Engine Joiner Rule Engine Date&Time Shift Rank Rank String to Date&Time Shuffle Shuffle Counter Generation Counter Generation Rank Rank Sorter Rule Engine Rule Engine Rule Engine Tries to match all order id linesregardless of sequence, and then filtersout based on time window, and marksquantity mismatches Tries to match all order id lines using bothorder id and row sequence, marks rowsbased on time window, and marksquantity mismatches.Assumes that all rows in Table 2 will beexactly same sequence as Table 1 Tries to match all order id lines using bothorder id and a ranking within order_id /order_number, marks rows based ontime window, and marksquantity mismatches.Assumes that all rows *for any givenorder* in Table 2 will be in samesequence as Table 1 Tries to match all order id lines using both order idand a ranking within order_id / order_number,marks rows based on time window, and marksquantity mismatches.Assumes that rows might appear in any order, butthat they should be compared in order of datetime for any given order Table 2 will be in samesequence as Table 1 Table 1 (A)Table 2 (B)Join on order idUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Calc 2 hour windowfrom table1 transaction timeRemove thosematched order numbers that aren't within windowFlagQty MismatchTable 2 (B)Use a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Join on order idand row counterFlagQty MismatchTable 1 (A)Calc 2 hour windowfrom table1 transaction timerow counterrow counterJoin on order idand rankingTable 1 (A)Table 2 (B)Calc 2 hour windowfrom table1 transaction timeUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]FlagQty MismatchTable 1 (A)Table 2 (B)Use a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Find those " outside window"Join on order idand rankingFlagQty MismatchCalc 2 hour windowfrom table1 transaction timerank in order of Order Number and Transaction Daterank in order of Order ID and PERFORMED_DATEUse a "permissive"date format maskM[/][-]d[/][-][yyyy][yy] H:m[:s]Mix up the rowsMix up the rowsrow counterrow counterRank each orderline in sequenceRank each orderline in sequencesort byorder numberand txn date/time(as we shuffled at beginning)Find those " outside window"Find those " outside window"Find those " outside window" Table Creator Table Creator Joiner String to Date&Time Date&Time Shift Row Filter Rule Engine Table Creator String to Date&Time Joiner Rule Engine Table Creator Date&Time Shift Counter Generation Counter Generation Joiner Table Creator Table Creator Date&Time Shift String to Date&Time Rule Engine Table Creator Table Creator String to Date&Time Rule Engine Joiner Rule Engine Date&Time Shift Rank Rank String to Date&Time Shuffle Shuffle Counter Generation Counter Generation Rank Rank Sorter Rule Engine Rule Engine Rule Engine

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-11
On NodePit since: 2022-02-06
Last update: 2024-05-02
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!