{"title":"DB Binner","nodeType":"Manipulator","id":"*Sd8c1CzpChHCo_Qn","factoryName":"org.knime.database.node.manipulation.binner.DBBinnerNodeFactory","factoryId":"org.knime.database.node.manipulation.binner.DBBinnerNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Groups numeric columns into discrete intervals, known as bins. This node supports both automatically binning to equal-width intervals and a manual binning method. Each bin is assigned a label based on its position, boundary values, or midpoint. The resulting binned values are output as string-type columns, either replacing the original data or appended alongside it.</p>\n        ","shortDescription":"Groups numeric values into labeled bins using automatic or custom-defined intervals.","keywords":["database","db","Auto Binner","Numeric Binner"],"deprecated":false,"streamable":false,"tags":["DB","Query"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAFjSURBVDiNpZO9ahtREIW/c7UBiTVYcR2FW6hw5ScwQm+QwqC3SO9ncOlSZSoF1Ma9G4OQUeHCIBdWEQuMlcQ2ONz1jzQppIX16hcycIrLzBzmnJkrM2NRSFqcyEUk6QK4nOHczE7SZEpeKBRex+PxhyRJKJVKhBAoFotImtbl0J41WhrOuRczsxCCARZCMJsWmVsw1b6kaJPxAbKFf4Az4NDM3iTRaDROK5XKLrCziuQL8NnMyCIra5WEtFjAJ+Ar0AG2NyYAroEk0/A0I7Rms9lptVqjdQT5LXxPJXjvO/V6fY6gVquNvPedLMED0zs4Aj6u8yCLCNgys7+po5KKkgpr9zcLx/Qa9yQdSPoG3AElgG63+7vX673kmwaDwfNwOByl7/xYt6mEOI771Wr1UdJzHMd97/09YOVyOYmi6NcyE4+zHjjnJrktzXlwBfwEboAfQPudRudsMpks9UD/+53/AQTLEfgiFXmvAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data to define bins for."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Binned DB Data","description":"DB Data with bins defined."},{"objectClass":"org.knime.core.node.port.pmml.PMMLPortObject","color":"1469af","dataType":"PMML","optional":false,"name":"PMML Model","description":"PMML document containing binning parameters."}],"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":"Columns to bin","description":"Select the numeric columns to apply binning to. Only the selected columns will be transformed.","optional":false},{"name":"Binning type","description":"Select the method used to define bin intervals.\n<ul><li><b>Equal width</b> : Creates bins of equal size across the value range. Requires a specified number of bins.</li><li><b>Custom cutoffs</b> : Manually define bin edges using a list of cutoff values. At least two cutoffs are required.</li></ul>","optional":false},{"name":"Number of bins","description":"Specifies the number of bins to create. Used with Equal width and Equal frequency binning.","optional":false},{"name":"Custom cutoffs","description":"Specifies the exact value at which the bin boundary should be placed.\n<ul><li><b>Cutoff</b> : Specifies the exact value at which the bin boundary should be placed.</li><li><b>Exact match</b> : Defines how to assign values that match a cutoff exactly.\n  <ul><li><b>To lower bin</b> : Assign to the bin below the cutoff.</li><li><b>To upper bin</b> : Assign to the bin above the cutoff.</li></ul></li></ul>","optional":false},{"name":"Enforce integer cutoffs","description":"If enabled, bin boundaries will be rounded to the nearest integer. Not available when using custom cutoffs.","optional":false},{"name":"Bin names/values","description":"Selects how bins are labeled in the output. Use a &#39;Number Format Manager&#39; node to customize number formatting.\n<ul><li><b>Numbered (e.g., Bin 1, Bin 2)</b> : Bins are labeled by index.</li><li><b>Borders (e.g., [0.0, 1.0))</b> : Bins are labeled using interval borders.</li><li><b>Midpoints</b> : Bins are labeled using the midpoint of each interval.</li></ul>","optional":false},{"name":"Prefix","description":"Text to prepend to bin labels when using numbered naming (e.g., Bin 1, Bin 2).","optional":false},{"name":"Lower outlier name/value","description":"Label assigned to values below the first.","optional":false},{"name":"Upper outlier name/value","description":"Label assigned to values above the last bin.","optional":false},{"name":"Output columns","description":"Whether to replace the original columns with the binned columns, or to append the binned columns with new names created by appending the specified suffix to the original column names.\n<ul><li><b>Replace</b> : Replaces the original column with the binned result.</li><li><b>Append with suffix</b> : Adds a new column with the binned values.</li></ul>","optional":false},{"name":"Suffix","description":"Text appended to column names when new columns are created using the Append option.","optional":false},{"name":"Number formatting","description":"Determine which number format should be applied if bin naming is either &#39;Borders&#39; or &#39;Midpoints&#39;. Choose <i>Advanced</i> to customize the number format using additional settings.","optional":false},{"name":"Minimum number of decimals","description":"The formatted number will show trailing zeros until the requested number of decimals are reached. For instance, <tt>1.2</tt> with 2 decimals is shown as <tt>1.20</tt> .","optional":false},{"name":"Maximum number of decimals","description":"The formatted number is rounded to the given number of decimals. For instance, <tt>1.2599</tt> with 2 decimals is shown as <tt>1.26</tt> .","optional":false},{"name":"Group separator","description":"The separator between groups of integer digits. For instance, <tt>1,000,000</tt> uses a comma and <tt>1&#39;000&#39;000</tt> uses an apostrophe as group separator.","optional":false},{"name":"Decimal separator","description":"The decimal separator to use.","optional":false},{"name":"Always show decimal separator","description":"Whether to always show the decimal separator, even if no fractional digits are present. If enabled, output like <tt>1.</tt> can be generated. If disabled, the same input would be shown as <tt>1</tt> .","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"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":[]}