Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other properties, such as delimiter to separate the different cell contents and quoting options.
\n ","shortDescription":"Combines the content of a set of columns and appends the concatenated string as separate column to the input table.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6OUY3MDg2QzY4Nzk1MTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6OUY3MDg2QzU4Nzk1MTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDowMTRGRDdBRjE4MzUxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDowMTRGRDdCMDE4MzUxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pp2rY+cAAACbSURBVHjarFMBCoAgDNzEPwT1p+oz9Yg+U/2poF8srQxNXZIdCDIPt9ttEgAIAiAiVDB3UPcgT5RFdRDsE0OIJyATknvkqnn9QOuvx878gDFetgSRWnpMDioXaN2WO9BMPZtxbgdHZrYErwKrErSGDFVmCjVaxBxIibEu2Fo/DxLn/29zALqJT5y2k7NAV8zjIbfOpnncOu8CDAAY3XJxAoxC2AAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"Arbitrary input data."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output Table","description":"Input data + additional column containing string combination."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Input columns","description":"Select the columns to combine in the output table.","optional":false},{"name":"Fail if there are missing columns","description":"If true the node will fail when there are missing columns selected","optional":false},{"name":"Delimiter","description":"Enter a delimiter string here. This string is used to separate the different cell contents in the new, appended column.","optional":false},{"name":"Handle delimiter inputs","description":"","optional":false},{"name":"Quote character","description":"The character entered here will be used to quote the cell content in case that it contains the delimiter string (for instance if the cell content is some;value , the delimiter string is ';' (a single semicolon), and the quote character is '"' (single quote char) the quoted string will be "some;value" (including quotes)). You can force quotation by checking "Quote Always". Alternatively, the user can also replace the delimiter string in the cell content string (see below).","optional":false},{"name":"Quote inputs","description":"","optional":false},{"name":"Replacement","description":"If the string representation of the cell content contains the delimiter string, it will be replaced by the string entered here (if you entered '-' here, the output of the above example would be some-value ).","optional":false},{"name":"Output column name","description":"The name of the new column.","optional":false},{"name":"Remove input columns","description":"If selected, removes the columns in the "Include" list from the output.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:552210dd-3dfc-4b47-bbe6-477d972e6b9e","user":"nilotpalc","date":"2022-09-30T16:26:36+00:00"},{"accountId":"account:user:28a71d82-95c8-4e09-9b30-9e19f67446a1","user":"akai","date":"2024-02-05T07:47:25+00:00"}],"kudosCount":2,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.13075060532687652},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.0847457627118644},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.06860371267150928},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.05367231638418079},{"id":"*kg6wiYxLaACvn7qm","factoryName":"org.knime.base.node.preproc.stringreplacer.StringReplacerNodeFactory","probability":0.04963680387409201},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.03631961259079903},{"id":"*_3lbfRYUi6sJ5AQm","factoryName":"org.knime.base.node.preproc.colcombine2.ColCombine2NodeFactory","probability":0.03066989507667474},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.026230831315577078},{"id":"*sLTXYsycpYMwt_yW","factoryName":"org.knime.time.node.convert.stringtodatetime.StringToDateTimeNodeFactory","probability":0.025423728813559324},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.021791767554479417}]}