{"title":"DB Pivot","nodeType":"Manipulator","id":"*gIBWKlZplEZzaz2M","factoryName":"org.knime.database.node.manipulation.pivot.DBPivotNodeFactory","factoryId":"org.knime.database.node.manipulation.pivot.DBPivotNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node pivots the input DB Data table using the selected columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each unique set of column combinations together with each aggregation method.</p>\n            \n        \n        ","shortDescription":"The DB Pivot node allows to pivot and group the input DB Data table by the selected columns for pivoting and grouping; enhanced by column aggregations.","keywords":["database","db"],"deprecated":false,"streamable":false,"tags":["DB","Query"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAEGSURBVDiNrdEvSwRRFAXw3+ysOpZFTLKwWMRit+yXsPopDAaj2Wyy2S0mxWgSq1FBBJPIhp2RFQS5hhllnN3FFT1weO/e9+65//gjUtxiG5tIcPdbkWjwHEmappFlWWRZFmmaNv8EopUkz0ll1JFjBaOIUBSFTqdjeNgfy9zdvSpaNfsNZ+jjddby28r+H3GDYtbAJhKsYgfXWEJEROR5PrF/RJJ4aiun3sNCJTbCcEqSb4ighbVaMFwaH2wTPRx8CVV8wJFyAya0UMc+BtiAZczXHhcx94MAnFBu4R3rFbcqdqeUvle7p80WPjmY4p+I9gTfaXWOTX2awD1elOu8wPEsgf+GDyFqZmdnrOd8AAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data to apply pivoting."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Pivoted DB Data","description":"DB Data with pivoted rows."}],"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":"Group columns","description":"Select one or more columns according to which the group rows are created.","optional":false},{"name":"Pivot columns","description":"Select one or more columns according to which the pivot columns are created.","optional":false},{"name":"Aggregation","description":"Select one or more columns for aggregation from the available columns list. Change the aggregation method in the Aggregation column of the table. You can add the same column multiple times.\n<ul><li><b>Column</b> : The column to aggregate</li><li><b>Aggregation</b> : The aggregation method to use</li></ul>","optional":false},{"name":"Column name","description":"The name of the resulting pivot column(s) depends on the selected naming schema.\n<ul><li><b>Pivot name&#43;Aggregation name</b> : Uses the pivot name first and the aggregation name second joint by a &#39;&#43;&#39; character. Keeps the original column names. Note that you can use all aggregation columns only once with this column naming option to prevent duplicate column names.</li><li><b>Aggregation name&#43;Pivot name</b> : Uses the aggregation name first and the pivot name second joint by a &#39;&#43;&#39; character.</li><li><b>Pivot name</b> : Uses solely the pivot name. Note that this option solely supports the selection of a single aggregation method to ensure uniqueness of the column names.</li></ul>","optional":false},{"name":"Aggregation name","description":"The name of the resulting aggregation column(s) depends on the selected naming schema.\n<ul><li><b>Keep original name(s)</b> : Keeps the original column names. Note that you can use all aggregation columns only once with this column naming option to prevent duplicate column names.</li><li><b>Aggregation method (column name)</b> : Uses the aggregation method first and appends the column name in brackets.</li><li><b>Column name (aggregation method)</b> : Uses the column name first and appends aggregation method in brackets.</li></ul>","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":[{"id":"*IDC5CmBOHvpj1hoo","factoryName":"org.knime.base.node.io.database.DBConnectionNodeFactory","probability":0.5},{"id":"*LRLx-cdMiV7H2TRq","factoryName":"org.knime.database.node.io.reader.DBReaderNodeFactory","probability":0.5}]}