{"title":"DB Concatenate","nodeType":"Manipulator","id":"*MBPKzHa0NhiQYeqd","factoryName":"org.knime.database.node.manipulation.concatenate.DBConcatenateNodeFactory","factoryId":"org.knime.database.node.manipulation.concatenate.DBConcatenateNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node concatenates two or more database tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated (if the column types differ the column type is the common base type of both input column types). If one input table contains column names that the other table does not, the columns can either be filled with missing values or filtered out, i.e. they will not be in the output table.</p>\n        ","shortDescription":"Concatenates two database tables.","keywords":["database","table","concat","row","column","duplicate","union","intersect"],"deprecated":false,"streamable":false,"tags":["DB","Query"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFgAAABNCAYAAAAijqMcAAAACXBIWXMAAD2DAAA9gwGH6AkLAAAGjklEQVR4nO2d65EaRxDHe1T3XecIjCMwisCr71QJJ4C4CHyKwFwEJgMBCZir4ruWCI7NADI4ImhXn3rwaJmdxz56B8G/aqtUty/4qaenp7t3UQCA8F0FALzC/9rzRn/b0b8RcQ83RckEHKotA89pQ8TXG/Jq1QFcVsGwF4i4E/rcF6M2AJsi2HMAWN8s+7vaBqx1ZNDzawfdFWCtAwBMETHv8B5J613HH+5XAPimlJpdOKfa6tqCTS0RcSp0r2QkCZj0JyKuE2fSqqQBHxHxXvB+tTRa5QMAyABgYJxPi6zdZpJFhaLSgCFlKx6t8jEA0Hzxu+MwmrgXtG0mmXdl2wfgJ0RMbtIbrXKC9jnytCcKRTeTrDIU7TqKuAjVhEv6m9zGaJUPqw7oA3BS7mG0ymc14WpRKPoyWuXWCEnaRRwQcRBwnIgYytcW7/WwmWQL8w/SgD+msqqLgFvwqKPoh1zBH57jP5iRhiTgB0RcBBzXuQLhUj5lvJlkPxgEh3BT9r82UZQx1BOfBOAj5yOS8L0civ3rOYw+c+aKeXliI/jvLbufNpPsLVLqGvCW4SZRCfFA0fLCNa5Hi5FvFdcgK953FUVs2d9mCcG9Z1/aClwSu4+tZRfd4xE6CNOWBtjUUpQzDqmqFAXXUNX3fAvb2nARz2wZyVYxHENZqy5c37U/3MVekIeELnheSiLdtTSvDZfliuuHVYB1CV+X7unmu0ss23NYVRW7nuCyJWb8vReu/EJJmWPfQBkH7H7G+tloldNk849l15G/+54t/K/SvsfyqsxybYpKXhyHPLyjYc7bz1qctCViDoa15iW4wFHAV7Z+q4yQz6XdNWTTypAKhn7Prs+V+7VmyQLj6YJcjyhgpdSUNsl7MkStgi13zDO/CxDYALOv9sGFruLgMyml7qmqrJTa8/pfOpumAT8z3HndDBrnMEL+Y550DqNOmBYkpRRZybhhrrUNrdkSZ1zq+RRxzVPUFJF9O+UhSAqxvVSEUmrIK5ixY9UknrLkyWrt8bdlLTeTbMrnzy0ToU1n+eBGFkzD3/BpmWcp2osCJ6SyTLih5aQzuBALWCk14OGmg/IYixAXpyYXdeBycijUpVjhQtlFMEA9CQ1Kmy+TH6pf6sTc/IXHln4FHcuuzTJ6zXLQGyi+Vx5gQNakvKk7pZRo2T4WLvvPGcOtssRPeokL9avEsXALhutMH3QWRVToEHMwV3wfA4b4aYg2hBvqrynkm4bkK6QBByeLYieXCMurOj+02jHbTLJ56MWlAQeFZ4FwzUxYHbhHtkJdK3RNhqeG8ogs25uS666sAbdOGGbNAfO1xqVjc9ck5pM04N9cOWUhuAeenEQe2JF0EYcquJFhkYZbJwwr+Hyx1KxkNs3qGtgK9wFwDwbcAfvEGG2l4YKwBZ8BCSylg8XyQkI3U6elr7SkAC8r3MMiIH9hG9aV7aIWfdFhFf+HznniEmnjkgBc6OSzKU5c+9b5VT4zZJj/EIZZMmoigLv2wdSIklUsj8+gl+SakHxwtL/WcIel8lDMCGikrgAfOOad2uDyUHVZr3O2Z3APjnOHOgzjaOOl5LPFsoBtu4gtPxTuszCfBT36Znte3uY8EobsNtamb3WU7MXUBuCt0TrVSmNK6MqJM1lWV+NZtNga9jpRDGD9oXLd7ZPq6wsCVoRiHUoE+KNjfy/dPjQp1V3KBi63xTrt73pq4PPBmwZEGWcKhPvcJHkTq146e3gCKxyH6JpYsALhFrpvV0p9tk65cgnvY3INoZbbRy6i1b4I542UynjY7/SjtKNVvvcslZeukC0iC9dbLqJTC+a2KepH23HLUXlx4fOzn/lR1Vn5cVUuyScNF7qyYO7wIXi2SvAXRDwN/wbPCYeosl9BSq2t5ALbpsASQeiVWNvL197hQhML5iaVzGidCs3PnvWmNagI29T0mYtWFQTY6PjJ2NqGDfrQrM1/LUFOCi5w0TMzHnTWuje6wFsduoioXPsb+GTRYmaoxN944gMM9Zr2gjttpCUNeEtPgYYcyC7j0VN/23KnTbLP60kDfkbEcmOHV8YzbFqv5W7KVCUNOMkXInUp6VzE1b3DUtqCazVfX7IkLXh7ja+6lQScxPt6pCXlImiFNbhZcHeaXeubsCUAP5npyWtTl71pSb3Oqy91YcFHfisp+dyrhgstW3Ch36t77b88YKoJ4IN+ORK/IOn2MzwWVQE+lko7O+M3jV6v+WcbogQA/wF9y21D+EdM7QAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"First DB Data to concatenate","description":"First DB Data Table to concatenate."},{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Second DB Data to concatenate","description":"Second DB Data Table to concatenate."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Concatenated DB Data","description":"Concatenated DB Data tables."}],"dynInPorts":[{"groupName":"input","groupDescription":"Additional DB Data Tables to concatenate.","types":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data"}]}],"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":"How to combine input columns","description":"Choose the output column selection process:\n<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 every input table. Any other column is ignored and won&#39;t appear in the output table.</li></ul>","optional":false},{"name":"Row handling","description":"Choose how to handle RowIDs:\n<ul><li><b>Keep all:</b> Keeps duplicated rows in the output table. <i>Union All</i> SQL operator will be used</li><li><b>Remove duplicates:</b> Removes duplicated rows from the output table. <i>Union</i> SQL operator will be used.</li></ul>","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:5592d1da-7401-4df1-a223-733bcc6a67b3","user":"leventsenol","date":"2022-12-01T13:42:53+00:00"},{"accountId":"account:user:552210dd-3dfc-4b47-bbe6-477d972e6b9e","user":"nilotpalc","date":"2022-08-07T15:27:30+00:00"}],"kudosCount":2,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}