Icon

Matched and Unmatched Pairings

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

supplied sample datavalues only Match andlabelDEFINE THRESHOLDcreate array listof valuesfor javatransformlists back into rows "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 snippetkeep 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 numberTable Creator Java Snippet Variable Creator GroupBy Ungroup Java Snippet Column Filter RowID Joiner Rule-basedRow Splitter Math Formula Column Rename Table Manipulator Rule Engine Rule Engine supplied sample datavalues only Match andlabelDEFINE THRESHOLDcreate array listof valuesfor javatransformlists back into rows "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 snippetkeep 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 number Table Creator Java Snippet Variable Creator GroupBy Ungroup Java Snippet Column Filter RowID Joiner Rule-basedRow Splitter Math Formula Column Rename Table Manipulator Rule Engine Rule Engine

Nodes

Extensions

Links