Performs a cross join of two tables. Each row of the top table is joined with each row of the bottom table. Note, this is an extremely expensive operation as the number of rows in the output is the product of both input table row counts, by increasing the chunk size there will be a speed up.
Note: If executed in streaming mode only the top input will be processed in a streamable fashion.
\n \n \n ","shortDescription":"Performs a cross join of two tables.","keywords":["Append fields"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6OTg3RThERjg4N0NCMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MjNEQzIzMUU4N0M4MTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpEOTJFN0JGQjE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpEOTJFN0JGQzE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PoJBHhEAAAEZSURBVHjadFNLbgIxDLURl2COgYAt03WhILGHFSs23KDnaHflBFC1a9JtV9wBCY5h7GgcHE/mSVY+sl/ecxIgIvDx+nWm4e498AiCj9E43N4WxNHK7UkCIoKimeNgUk/v/yFI8byqprIHBlrTh24ICc2vF+gqjhAZOurcyvZ2bE6y4FlV9na1R2unRIJ2IfgcTzLPTJIOZJI/Jqt/1nXKz5roiwW/mxfbk6hkdgh5E1WFLx6cjqD6pEgba2uigvtiSRIqtQkPu09MSInAX5OuWSZJlHK4D2gJbAK2HsTzhlo5kaD6PvmE6N+dCE33swOSAiXhkSSM9OjZ2Xmq8u+gWVMpSrm9Dr9Y+hvZH/AWWndGhKW5x0OAAQBqOLHyxQg5HgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Top Table","description":"The top table to be joined (streamable)"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Bottom Table","description":"The bottom table to be joined (non-streamable)"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Joined Table","description":"Cross join"}],"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":"Bottom table's column name suffix","description":"The suffix attached to a column's name if the bottom table contains a column with the same name. The column names of the first inport are always retained. If there are duplicates found in the second table the suffix is added once or multiple times to ensure uniqueness.","optional":false},{"name":"Separator for new RowIDs","description":"This string will separate the RowIDs in the new data table. E.g. RowID1 + sep + RowID2","optional":false},{"name":"Chunk size","description":"Number of rows read at once. Increasing this value yields faster execution time but also increases memory consumption.","optional":false},{"name":"Append top data table's RowIDs","description":"If selected a new column will be attached to the output, containing the RowIDs of the top data table.","optional":false},{"name":"Column name (top)","description":"Name of the column containing the RowIDs from the top table","optional":false},{"name":"Append bottom data table's RowIDs","description":"If selected a new column will be attached to the output, containing the RowIDs of the bottom data table.","optional":false},{"name":"Column name (bottom)","description":"Name of the column containing the RowIDs from the bottom table","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"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":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.11472945891783567},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.08316633266533066},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.06212424849699399},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.05260521042084168},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.04759519038076152},{"id":"*HG3L-oE4gau2HJVb","factoryName":"org.knime.base.node.preproc.crossjoin.CrossJoinerNodeFactory","probability":0.04659318637274549},{"id":"*Q-yW-3C9DumtInuz","factoryName":"org.knime.base.node.rules.engine.RuleEngineFilterNodeFactory","probability":0.04408817635270541},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.03557114228456914},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.02905811623246493},{"id":"*zpGPAjDyExkFL2HB","factoryName":"org.knime.base.node.rules.engine.RuleEngineNodeFactory","probability":0.024549098196392786}]}