> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# aggregateUnpivotRaw

<div className="kinetica-doxygen">
  <div id="a147bb1df6e7e6a862c49f148642bde3b" />

  <h2 className="memtitle"><span className="permalink"><a href="#a147bb1df6e7e6a862c49f148642bde3b">◆ </a></span>aggregateUnpivotRaw() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">RawAggregateUnpivotResponse</a> gpudb::GPUdb::aggregateUnpivotRaw </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1AggregateUnpivotRequest">AggregateUnpivotRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
          <td>)</td>
          <td> const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Rotate the column values into rows values. </p>
      <p>For unpivot details and examples, see <a href="/content/concepts/unpivot/" target="_top">Unpivot</a>. For limitations, see <a href="/content/concepts/unpivot/#limitations" target="_top">Unpivot Limitations</a>.</p>
      <p>Unpivot is used to normalize tables that are built for cross tabular reporting purposes. The unpivot operator rotates the column values for all the pivoted columns. A variable column, value column and all columns from the source table except the unpivot columns are projected into the result table. The variable column and value columns in the result table indicate the pivoted column name and values respectively.</p>
      <p>The response is returned as a dynamic schema. For details see: <a href="/content/api/concepts/#dynamic-schemas" target="_top">dynamic schemas documentation</a>.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1AggregateUnpivotRequest">Request</a> object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">Response</a> object containing the result of the operation. </div>
      </div>
    </div>
  </div>

  <div id="ac1b8c35f677977449dee7e9d7361c1b1" />

  <h2 className="memtitle"><span className="permalink"><a href="#ac1b8c35f677977449dee7e9d7361c1b1">◆ </a></span>aggregateUnpivotRaw() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">RawAggregateUnpivotResponse</a> & gpudb::GPUdb::aggregateUnpivotRaw </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1AggregateUnpivotRequest">AggregateUnpivotRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
        </tr>

        <tr>
          <td className="paramkey" />

          <td />

          <td className="paramtype"><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">RawAggregateUnpivotResponse</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">response\_</span></span> ) const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Rotate the column values into rows values. </p>
      <p>For unpivot details and examples, see <a href="/content/concepts/unpivot/" target="_top">Unpivot</a>. For limitations, see <a href="/content/concepts/unpivot/#limitations" target="_top">Unpivot Limitations</a>.</p>
      <p>Unpivot is used to normalize tables that are built for cross tabular reporting purposes. The unpivot operator rotates the column values for all the pivoted columns. A variable column, value column and all columns from the source table except the unpivot columns are projected into the result table. The variable column and value columns in the result table indicate the pivoted column name and values respectively.</p>
      <p>The response is returned as a dynamic schema. For details see: <a href="/content/api/concepts/#dynamic-schemas" target="_top">dynamic schemas documentation</a>.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1AggregateUnpivotRequest">Request</a> object containing the parameters for the operation. </td>
            </tr>

            <tr>
              <td className="paramdir">\[out]</td>
              <td className="paramname">response\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">Response</a> object containing the results of the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1RawAggregateUnpivotResponse">Response</a> object containing the result of the operation (initially passed in by reference). </div>
      </div>
    </div>
  </div>
</div>