Icon

checking values in 2 columns

This is an answer to a question posted on the KNIME forum at: https://forum.knime.com/t/checking-values-in-2-columns/70577. The question wasI am trying to compare 2 columns to make sure that all data in column A also exist in column B but not necessary in the same rowColumn A does not contain any duplicatesColumn B contain duplicates and that is fineI just want to make sure that each value in column A also exist somewhere in column B. Column AExist inColumn BNot all of Column Ais in Column BNode 3Node 4LooksformacthesNode 6Node 7Node 8first rowonlyHard codesany non matchesAExistsInBColumn OnlyNode 26Node 27Node 28Node 42 Table Creator Table Creator Sorter Sorter Rule Engine Column Filter Column Filter Column Appender Row Filter Java Snippet Column Filter Extract TableDimension Table Rowto Variable Java EditVariable (simple) Does Column A existsomewhere in column B? This is an answer to a question posted on the KNIME forum at: https://forum.knime.com/t/checking-values-in-2-columns/70577. The question wasI am trying to compare 2 columns to make sure that all data in column A also exist in column B but not necessary in the same rowColumn A does not contain any duplicatesColumn B contain duplicates and that is fineI just want to make sure that each value in column A also exist somewhere in column B. Column AExist inColumn BNot all of Column Ais in Column BNode 3Node 4LooksformacthesNode 6Node 7Node 8first rowonlyHard codesany non matchesAExistsInBColumn OnlyNode 26Node 27Node 28Node 42Table Creator Table Creator Sorter Sorter Rule Engine Column Filter Column Filter Column Appender Row Filter Java Snippet Column Filter Extract TableDimension Table Rowto Variable Java EditVariable (simple) Does Column A existsomewhere in column B?

Nodes

Extensions

Links