13 docs tagged with "Table manipulation"

Renames a column or expression with an alias.

Sorts a column in ascending order.

Combines multiple tables into a single table.

Sorts a column in descending order.

Fills gaps in inventory data by generating missing date/product combinations.

Generates a series of values between a start and end value.

Performs a left join between two tables.

Sorts a table by one or more columns in ascending or descending order.

Creates a pivot table with indexed values.

Selects specific columns from a table.

Creates a summary table based on specified columns and optional filter expressions.

Returns the top N rows based on a specified column.

Combines rows from multiple tables.