Icon

Conditional Concatenate

Corresponding Forum Posthttps://forum.knime.com/t/conditional-concatenate-if-aggregation/58900 ImportantString Manipulation (Multi Column) struggles withmissing values! Hence, missing is converted toempty before RegEx and then converted back.I had reported that back in 2021 but to no avail. I willraise this once more.https://forum.knime.com/t/string-manipulation-multi-column-fails-with-nullpointerexception-for-missing-values/31549 Row Index (Int)to re-establishsort order laterExtractLetter fromRecord IDExtractLetter fromRecord ID(cloned)Table Creator (#1) Rule Engine (#4) Regex Extractor(#7) Regex Extractor(#8) Table Creator (#12) Rule Engine(Dictionary) (#14) Regex Split (#15) String Manipulation(Multi Column) (#16) Regex Split (#17) Column Rename (#18) Rule Engine(Dictionary) (#19) Column Rename (#20) ConditionalConcat (#22) ConditionalConcat (#23) Table DifferenceChecker (#24) ConditionalConcat (#25) Table DifferenceChecker (#26) Table DifferenceChecker (#27) ConditionalConcat (#28) Corresponding Forum Posthttps://forum.knime.com/t/conditional-concatenate-if-aggregation/58900 ImportantString Manipulation (Multi Column) struggles withmissing values! Hence, missing is converted toempty before RegEx and then converted back.I had reported that back in 2021 but to no avail. I willraise this once more.https://forum.knime.com/t/string-manipulation-multi-column-fails-with-nullpointerexception-for-missing-values/31549 Row Index (Int)to re-establishsort order laterExtractLetter fromRecord IDExtractLetter fromRecord ID(cloned)Table Creator (#1) Rule Engine (#4) Regex Extractor(#7) Regex Extractor(#8) Table Creator (#12) Rule Engine(Dictionary) (#14) Regex Split (#15) String Manipulation(Multi Column) (#16) Regex Split (#17) Column Rename (#18) Rule Engine(Dictionary) (#19) Column Rename (#20) ConditionalConcat (#22) ConditionalConcat (#23) Table DifferenceChecker (#24) ConditionalConcat (#25) Table DifferenceChecker (#26) Table DifferenceChecker (#27) ConditionalConcat (#28)

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: mw
Created at: 2023-01-09
On NodePit since: 2023-01-10
Last update: 2024-04-28
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!