Icon

Matched and Unmatched Pairings - 2

Matched and Unmatched Pairings

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

supplied sample datavalues only Match andlabelDEFINE THRESHOLDtransformlists back into rowskeep just the required"pair sorted"listredorowidsjoin the matchedrowsdivide the"positive" and"negative" streamscalcdifferencerename colsas positiveand negativetidy upif negative is inpositive columnplace it in correct columni.e. when a valueis "unique" itis treated as positiveby the java snippetensurepositiveonly containspositive numbersupplied sample datavalues only(set 2) "pair-sort"with exact or close matches(interleaving best matchnegative and positive)The data may be supplied in any orderand this snippet should placeit in the "pairing" order required for matchingin the next java snippetcreate array listof valuesfor javasortabsolutevalue ofsortable keyUse +veand -vecolumns to create a "sortable key"tidy uptidy upTable Creator Java Snippet Variable Creator Ungroup Column Filter RowID Joiner Rule-basedRow Splitter Math Formula Column Rename Table Manipulator Rule Engine Rule Engine Table Creator Java Snippet GroupBy Sorter Math Formula Column Merger Column Filter RowID supplied sample datavalues only Match andlabelDEFINE THRESHOLDtransformlists back into rowskeep just the required"pair sorted"listredorowidsjoin the matchedrowsdivide the"positive" and"negative" streamscalcdifferencerename colsas positiveand negativetidy upif negative is inpositive columnplace it in correct columni.e. when a valueis "unique" itis treated as positiveby the java snippetensurepositiveonly containspositive numbersupplied sample datavalues only(set 2) "pair-sort"with exact or close matches(interleaving best matchnegative and positive)The data may be supplied in any orderand this snippet should placeit in the "pairing" order required for matchingin the next java snippetcreate array listof valuesfor javasortabsolutevalue ofsortable keyUse +veand -vecolumns to create a "sortable key"tidy uptidy up Table Creator Java Snippet Variable Creator Ungroup Column Filter RowID Joiner Rule-basedRow Splitter Math Formula Column Rename Table Manipulator Rule Engine Rule Engine Table Creator Java Snippet GroupBy Sorter Math Formula Column Merger Column Filter RowID

Nodes

Extensions

Links