{"title":"Concatenate","nodeType":"Manipulator","id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","factoryId":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","path":["Manipulation","Row","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node concatenates two or more tables. The table at inport 0 is the first input table (top input port), and the tables at subsequent inports are the additional input tables. Columns with the same names are concatenated (if the column types differ, the resulting column type will be the common base type of the input column types). If one input table contains column names that the other tables do not, the columns can either be filled with missing values or filtered out, meaning they will not appear in the output table. The dialog allows setting the following parameters:</p>\n        ","shortDescription":"Concatenates two or more tables row-wise.","keywords":["Row appender","Union","rbind"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6QzRBNDVGN0E4NjNBMTFFNUE1MkU5NUMxRjMyOENFRTgiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6QzRBNDVGNzk4NjNBMTFFNUE1MkU5NUMxRjMyOENFRTgiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDowREYyMzc5QTE2OEQxMUU1QkQ5NUExQjU5MUVDNkZCQiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDowREYyMzc5QjE2OEQxMUU1QkQ5NUExQjU5MUVDNkZCQiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PokpslcAAAFRSURBVHjaYvz//z8DJYCJgULAwsjISLRi74X784FUKxD/BeJZeh/utjGToDkPSE0E4s1A3A3EaS85hMRZgAyCgcAnp8Lw/98/BkYmprlAbt7WeMdvQAOFQQaB3P8fOSBBXkIP2C03nzLcf/eFYeft5y+A3BNAnAvEu4D4J85ABBny5ttPsPN4WFkY9t17CRIG2XoQash3IHZnwab55ptPDF2HroHZNvJiDGuvPmLgZGVm+P2XIQUoVAvEm4C4FOiVr4zoYSCqa8pgnNfM8O3VMwZeGcU2oFAVED8H4kCghpMY0QjyNrKzfRYdeAJkvgNqtgPSrkC8GogPA3E2EJ8kJiHxAvFVoG0fgBik+QwQTwLi01gTEhaxCiCeAoymX0CaA4jDgLjR9unJNVuxKGZED3lQNAI1pwG57VD5fMdX57aXlBa/weYCxgHPTBQbABBgAMjKdxgbj1UQAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"First table to concatenate","description":"Table contributing the rows of the first part of the output table."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Second table to concatenate","description":"Table contributing the rows of the second part of the output table."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Concatenated table","description":"Table with rows from all tables."}],"dynInPorts":[{"groupName":"input","groupDescription":"Tables contributing subsequent rows.","types":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table"}]}],"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":[{"fields":[{"name":"How to combine input columns","description":"<ul><li><b>Union:</b> Use all columns from all input tables. Fill rows with missing values if they miss cells for some columns.</li><li><b>Intersection:</b> Use only the columns that appear in all input tables. Any other column is ignored and won&#39;t appear in the output table. Columns are matched by name.</li></ul>","optional":false},{"name":"RowID handling","description":"Choose how to handle RowIDs:\n<ul><li><b>Create new:</b> Discard the RowIDs of the input tables and generate new RowIDs</li><li><b>Reuse existing:</b> Reuse the RowIDs of the input tables. This might lead to conflicts due to duplicate RowIDs, see <em>Duplicate RowID strategy</em> for different ways to resolve them.</li></ul>","optional":false},{"name":"Duplicate RowID strategy","description":"Select how duplicate RowIDs are handled:\n<ul><li><b>Append suffix</b> : The output table will include all rows, but duplicate RowIDs will have a suffix added. This method is also memory intensive, similar to the &#34;Skip&#34; option.</li><li><b>Skip</b> : Duplicate RowIDs in the additional tables are not added to the output table. This option is memory intensive because it caches the RowIDs to find duplicates and requires full data duplication.</li><li><b>Fail</b> : The node will fail during execution if duplicate RowIDs are encountered. This option is efficient for checking uniqueness.</li></ul>","optional":false},{"name":"Enable hiliting","description":"Advanced setting that enables hiliting between the inputs and the concatenated output table.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:498b0732-17cb-40a8-bc35-fccbe94ac93e","user":"nborbas","date":"2023-04-27T09:19:14+00:00"}],"kudosCount":1,"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":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.12183808522481292},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.09221349495949038},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.09066732636526686},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.06122827633125116},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.04465334900117509},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.034448636279299893},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.03240769373492486},{"id":"*gwwIZ5c5EYsJErci","factoryName":"org.knime.base.node.preproc.sorter.SorterNodeFactory","probability":0.02857319562125054},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.024924237738883047},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.023625456119735298}]}
