{"title":"DB Joiner","nodeType":"Manipulator","id":"*FWHpi7M8fzVHRit0","factoryName":"org.knime.database.node.manipulation.joiner.DBJoinNodeFactory","factoryId":"org.knime.database.node.manipulation.joiner.DBJoinNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node joins two DB Data tables. The join is based on the joining columns of both tables.</p>\n        ","shortDescription":"Joins two DB Data tables","keywords":["database","join","left","right","inner"],"deprecated":false,"streamable":true,"tags":["DB","Query","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NzNDNzJDNjE4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NzNDNzJDNjA4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBNzRGQkEwMTgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBNzRGQkEwMjgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PoKCI7cAAADNSURBVHjaYmZgYLgNxI5ALALE94H4GwOJ4D8SBmlOwCKHTx+KASD8BYtCXAYwMGGR6CbF+SxA/AeILwPxASCeD2WTZAA7EP9jIBMwoWlWBeJWLP7/jyNcwHQ6EE8F4mtYQr0Bym9AMwBFHD0W3uKJhf+EYmEvENuiiTHi8D4jLBBbgPgKEB8D4scMVAB6BFItRjQKQDU5A7EfEBvgcDZyyDPiygsg/BeH7bhiBEXzdyAuxJPo/kNpFMFb0EA8DsTLgPgZDgP+YPMaQIABAGhHRtSVuiNlAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Top DB Data Input ('left' table)","description":"DB Data referencing the left part of the joined output DB Data table."},{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Bottom DB Data Input ('right' table)","description":"DB Data referencing the left part of the joined output table."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Joined DB Data","description":"DB Data referencing the joined DB Data table."}],"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":"Match","description":"Defines the logic for the matching criteria:\n<ul><li><b>All of the following</b> : A row of the top input table and a row of the bottom input table match if they match in all specified column pairs.</li><li><b>Any of the following</b> : A row of the top input table and a row of the bottom input table match if they match in at least one specified column pairs.</li></ul>","optional":false},{"name":"Joining columns","description":"Select the columns from the top input (&#39;left&#39; table) and the bottom input (&#39;right&#39; table) that should be used for joining. You must make sure, that the type of selected columns matches.\n<ul><li><b>Top input (&#39;left&#39; table)</b> : Select the column from the top input table that should be used to compare with the column selected for the bottom input.</li><li><b>Bottom input (&#39;right&#39; table)</b> : Select the column from the bottom input table that should be used to compare with the column selected for the top input.</li></ul>","optional":false},{"name":"Left unmatched rows","description":"Include rows from the left input table for which no matching row in the right input table is found.","optional":false},{"name":"Right unmatched rows","description":"Include rows from the right input table for which no matching row in the left input table is found.","optional":false},{"name":"Top input ('left' table)","description":"Select the left columns for the select clause in the join statement.","optional":false},{"name":"Bottom input ('right' table)","description":"Select the right columns for the select clause in the join statement.","optional":false},{"name":"If there are duplicate column names","description":"The option allows you to change the behavior if the include lists of both input tables contain columns with the same name.\n<ul><li><b>Remove duplicates</b> : Only the columns from the top input table will show up in the output table.</li><li><b>Append automatic numeric suffix</b> : Append a suffix to the duplicate column names from the bottom input table so that they also show up in the output table.</li><li><b>Append custom suffix</b> : Append a suffix to the duplicate column names from the bottom input table so that they also show up in the output table.</li><li><b>Fail</b> : Don&#39;t allow to execute this node if there are duplicate column names in the include lists.</li></ul>","optional":false},{"name":"Custom suffix","description":"The suffix to be added to the column name of the right table","optional":false},{"name":"Remove joining columns from top input ('left' table)","description":"The option allows filtering the top (&#39;left&#39; table) joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.","optional":false},{"name":"Remove joining columns from bottom input ('right' table)","description":"The option allows filtering the bottom (&#39;right&#39; table) joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:b4449e61-4332-4355-92e9-02ead7c14a00","user":"samirabida","date":"2022-07-14T06:00:39+00:00"}],"kudosCount":1,"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":[{"id":"*d8TQIqNnO3XRVTjQ","factoryName":"org.knime.database.node.io.reader.DBReadNodeFactory","probability":0.5454545454545454},{"id":"*eTH6FxdMQbNIhJqB","factoryName":"org.knime.database.node.manipulation.sorter.DBSortNodeFactory","probability":0.09090909090909091},{"id":"*Ts6MTyaKUWegubym","factoryName":"org.knime.database.node.connector.tablewriter.DBConnectionTableWriterNodeFactory","probability":0.09090909090909091},{"id":"*v_ErMw_XNCPu_fk7","factoryName":"org.knime.database.node.manipulation.binning.numeric.DBBinnerNumericNodeFactory","probability":0.09090909090909091},{"id":"*XGaHanhyHTSgL1A1","factoryName":"org.knime.database.node.io.parameterizedquery.ParameterizedDBSQLQueryNodeFactory","probability":0.09090909090909091},{"id":"*YJIwMkiTMpJtVTUT","factoryName":"org.knime.database.node.manipulation.groupby.DBGroupByNodeFactory","probability":0.09090909090909091}]}