pivot_table.md

warning	title	excerpt	extension	repo	docs	extension_star_count	extension_star_count_pretty	extension_download_count	extension_download_count_pretty	image	layout
DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there	pivot_table	DuckDB Community Extensions Provides a spreadsheet-style pivot_table function	name description version language build license maintainers pivot_table Provides a spreadsheet-style pivot_table function 0.0.2 C++ cmake MIT Alex-Monahan	github ref Alex-Monahan/pivot_table 3e87d43b4c15a3640b26eb8942ce5e75335c879a	hello_world extended_description FROM pivot_table(['duckdb_databases'], [], ['database_name'], [], []); This extension, pivot_table, allow you to pivot your data using a spreadsheet-like pivot API. It is also similar to the Pandas pivot_table function. It does this solely through SQL macros - there are no C++ functions as a part of this extension.	13	13	604	604	/images/community_extensions/social_preview/preview_community_extension_pivot_table.png	community_extension_doc

Installing and Loading

INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};

{% if page.docs.hello_world %}

Example

{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|        function_name        | function_type | description | comment | examples |
|-----------------------------|---------------|-------------|---------|----------|
| build_my_enum               | table_macro   | NULL        | NULL    | []       |
| columns_values_axis_columns | macro         | NULL        | NULL    | []       |
| columns_values_axis_rows    | macro         | NULL        | NULL    | []       |
| dq                          | macro         | NULL        | NULL    | []       |
| dq_concat                   | macro         | NULL        | NULL    | []       |
| dq_list                     | macro         | NULL        | NULL    | []       |
| no_columns                  | macro         | NULL        | NULL    | []       |
| nq                          | macro         | NULL        | NULL    | []       |
| nq_concat                   | macro         | NULL        | NULL    | []       |
| nq_list                     | macro         | NULL        | NULL    | []       |
| pivot_table                 | scalar        | NULL        | NULL    | []       |
| pivot_table                 | table_macro   | NULL        | NULL    | []       |
| pivot_table_openssl_version | scalar        | NULL        | NULL    | []       |
| pivot_table_show_sql        | table_macro   | NULL        | NULL    | []       |
| replace_zzz                 | macro         | NULL        | NULL    | []       |
| sq                          | macro         | NULL        | NULL    | []       |
| sq_concat                   | macro         | NULL        | NULL    | []       |
| sq_list                     | macro         | NULL        | NULL    | []       |
| totals_list                 | macro         | NULL        | NULL    | []       |