> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/legacy/legacy-experience/automation-areas.md).

# Automation Areas

- [Charts](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts.md)
- [Add Legend](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/add-legend.md): Enables a legend on an existing pie chart.
- [Add Trendline](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/add-trendline.md): Add a linear or quadratic trendline to a scatter plot.
- [Create Chart](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/create-chart.md): Generates a bar or pie chart.
- [Create Plot](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/create-plot.md): Generates a scatter, line, or box plot.
- [Remove Legend](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/remove-legend.md): Removes the legend on an existing pie chart.
- [Save Chart](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/save-chart.md): Renders the current chart and saves it internally.
- [Show Chart](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/show-chart.md): Renders a previously created chart.
- [Show Plot](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/charts/show-plot.md): Render a stored plot chart.
- [Date and Time](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time.md): This section covers the automation procedures for working with dates and times in Kognitos.
- [Converting Date Strings Into Dates](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-into-dates.md): This procedure converts date strings (text representations of dates) into date objects.
- [Converting Date Strings to Different Formats](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-to-different-formats.md): This procedure converts text to a date in a specific format.
- [Converting Text to Date](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time/converting-text-to-date.md): This procedure converts text to date in YYYY-MM-DD format.
- [Getting Date and Time Information](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time/getting-date-and-time-information.md): These procedures are used to get current date and time information.
- [Sorting Dates](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/date-and-time/sorting-dates.md): This procedure sorts a list of dates in ascending order.
- [Department Boxes](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box.md): Learn how to operate on a department box.
- [Add Items](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/add-items.md): Add item(s) to a department box.
- [Clean Items](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/clean-items.md): Removes all the keys from the department box.
- [Clean Items Before a Certain Date](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/clean-items-before-a-certain-date.md): Removes all the keys from the department box before a certain date.
- [Export Items](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/export-items.md): Export all the keys from the specified department box into a table.
- [Migrate to OpenSearch](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/migrate-to-opensearch.md): Migrates data from the current department box storage engine to OpenSearch.
- [Remove Item](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/remove-item.md): Removes a specified item from a department's box.
- [Remove Items](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/remove-items.md): Removes all items from a department box.
- [Retrieve Item](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/department-box/retrieve-item.md): Retrieve an item from a department box.
- [Excel Files](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2.md): Learn to work with local Excel files in Kognitos.
- [Cells](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value.md): Retrieves the value of a cell in an Excel worksheet.
- [Get a Cell's Column Label](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-column-label.md): Retrieves the column label of a specific cell in an Excel worksheet.
- [Get a Cell's Formula](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-formula.md): Gets the formula from a specified cell in a worksheet.
- [Get a Cell's Row Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-row-number.md): Retrieves the row number of a specific cell in an Excel worksheet.
- [Set a Cell's Value](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-a-cells-value.md): Sets the value of a cell in a worksheet to a specified text or formula.
- [Set Cell Values](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-cell-values.md): Updates the values in an Excel file for one or more cells.
- [Columns](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/insert-a-column.md): Inserts a column into an existing Excel worksheet.
- [Rows](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-row.md): Gets a row from an Excel worksheet that contains a specific value.
- [Get a Row's Cell](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/get-a-rows-cell.md): Retrieves a cell in a specific row of an Excel worksheet.
- [Insert a Row](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/insert-a-row.md): Inserts a row into an existing Excel worksheet.
- [Tables](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet.md): Locates and extracts a table from an Excel worksheet.
- [Get a Singular Table from an Excel Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/get-a-singular-table-from-an-excel-worksheet.md): Retrieves the single table from a worksheet.
- [Insert a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/insert-a-table.md): Inserts a table into an Excel worksheet.
- [Workbooks](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf.md): Converts an Excel file to PDF format.
- [Create an Excel File](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf/create-an-excel-file.md): Creates a new Excel file.
- [Worksheets](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet.md): Gets a specific worksheet from an Excel file.
- [Add a Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/add-a-worksheet.md): Adds an empty worksheet to an existing Excel file.
- [Copy a Worksheet in the Excel](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/copy-a-worksheet-in-the-excel.md): Creates a copy of an existing worksheet in the same Excel file.
- [Extract Text from a Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/extract-text-from-a-worksheet.md): Extracts all text from an Excel worksheet
- [Format an Excel](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/format-an-excel.md): Formats cells in an Excel worksheet.
- [Get a Worksheet Name](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-a-worksheet-name.md): Intelligently retrieves a worksheet name from an Excel file.
- [Get an Item from an Excel Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-an-item-from-an-excel-worksheet.md): Retrieves a specific item from a sheet.
- [Get Worksheet Names](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheet-names.md): Retrieves the names of all worksheets in an Excel file.
- [Get Worksheets](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheets.md): Gets all the worksheets from an Excel workbook.
- [Insert a Formula into an Excel](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/insert-a-formula-into-an-excel.md): Inserts formulas into a specified column across multiple rows in an Excel worksheet.
- [Remove a Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/remove-a-worksheet.md): Removes a specified worksheet.
- [Rename a Worksheet in the Excel](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/rename-a-worksheet-in-the-excel.md): Renames an existing worksheet in the same Excel file.
- [Save a Worksheet](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/save-a-worksheet.md): Saves an Excel worksheet to a temporary location.
- [Files and Documents](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1.md)
- [JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file.md): Opens a JSON file from either an S3 URL or an uploaded file.
- [Compare a JSON with a JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-compare-a-json-with-a-json.md): Compares two JSON objects and identifies differences between them.
- [Create a JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-create-a-json.md): Creates an empty JSON object.
- [Delete a JSON's Thing](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-delete-a-jsons-thing.md): Deletes a specified key from a JSON object.
- [Get a JSON as a String](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-json-as-a-string.md): Converts a JSON object to a string representation.
- [Get a JSON's Thing](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-jsons-thing.md): Extracts a specific element or elements from a JSON structure.
- [Get a String as a JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-string-as-a-json.md): Converts a string to a JSON object.
- [Merge a JSON with a JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-merge-a-json-with-a-json.md): Merges two JSON objects and returns the merged result.
- [Set a JSON's Thing to a Thing](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-set-a-jsons-thing-to-a-thing.md): Sets or changes a specific value within a JSON object to a new value.
- [PDFs](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf.md): Automation procedures for converting files to PDF.
- [Getting Information from a PDF](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/getting-information-from-a-pdf.md): Basic procedures for extracting information from a PDF.
- [Merging Documents](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/merging-documents.md): This automation procedure combines multiple PDFs into a single PDF file.
- [Removing Duplicates from a PDF](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/removing-duplicates-from-a-pdf.md): Automation procedures for removing duplicates from a PDF file.
- [Saving a PDF](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/saving-a-pdf.md): Automation procedures for saving a PDF file after making changes.
- [Setting or Changing Information in a PDF](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/setting-or-changing-information-in-a-pdf.md): Automation procedures to set or change field values in a PDF file.
- [Unlock a PDF File](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/unlock-a-pdf-file.md): Unlocks a password-protected PDF file.
- [Templates](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template.md): Generates a PDF document for each row in an Excel file by merging data into a .docx template.
- [Fill in a Template File](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template/fill-in-a-template-file.md): Fills in a template with provided placeholder values.
- [Image Manipulation](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation.md): Automation procedures for image manipulation, including how to resize, rotate, convert to grayscale, and flip images.
- [Converting Images to Grayscale](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/converting-images-to-grayscale.md)
- [Flipping Images](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/flipping-images.md)
- [QR Code Generation](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/qr-code-generation.md)
- [Resizing Images](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/resizing-images.md)
- [Rotating Images](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/rotating-images.md)
- [Text Visualization](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/image-manipulation/text-visualization.md)
- [LLMs](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm.md): Learn how to use automation procedures that interact with LLM models.
- [When to Use Ask Koncierge or Extract](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/when-to-use-ask-koncierge-or-extract.md): Summarizing the differences, strengths, and use cases for each type of LLM procedure.
- [Foundational Procedures](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/ask-koncierge.md)
- [Ask Koncierge](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge.md): Asks Koncierge, a virtual assistant, to perform a task, answer a question, or generate a message.
- [Ask Koncierge to Extract Information from a Document](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge-to-extract-information-from-a-document.md): Asks Koncierge to extract specific information from documents or text.
- [Automation Procedures](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data from Multiple Documents](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data-from-multiple-documents.md): Extracts data from multiple documents in a single LLM call using file upload.
- [Extract Pages](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-pages.md): Extracts specified pages from a document or file as individual page documents.
- [Extract Subdocument](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocument.md): Extracts a subdocument from a document or file based on page numbers or markers.
- [Extract Subdocuments](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocuments.md): Extracts multiple subdocuments from a document using markers or fixed-size chunking.
- [Extract Tables](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-tables.md): Extracts table data from documents, text, or files using AI-powered analysis.
- [Identify Elements in a Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/identify-elements-in-a-text.md): Finds a specified element within a given text using AI-powered text analysis.
- [Merge Pages into Document](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-pages-into-document.md): Merges multiple page documents into a single consolidated document.
- [Merge Subdocuments into Document](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-subdocuments-into-document.md): Merges multiple subdocuments into a single consolidated document.
- [Query Multiple Documents](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/llm/automation-procedures/query-multiple-documents.md): Process multiple documents with a custom prompt using LLM file upload APIs.
- [Numbers](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/numbers.md): Automation procedures for working with numbers in Kognitos.
- [Increase a Number by a Percentage](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/numbers/increase-a-number-by-a-percentage.md): This procedure increases a number by a percentage.
- [Reduce a Number by a Percentage](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/numbers/reduce-a-number-by-a-percentage.md): This procedure reduces a number by a percentage
- [Truncate a Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/numbers/truncate-a-number.md): Truncates a decimal number to a specified precision without rounding.
- [Tables](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2.md): Learn to work with tables and tabular data.
- [Table Creation](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table.md): Creates an empty table. The column names and number of rows can be optionally specified.
- [Create a Combined Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-combined-table.md): Creates a combined table from two or more existing tables.
- [Create a Merged Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-merged-table.md): Merge two or more tables based on specified matching and merging criteria.
- [Create a Pivot Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-pivot-table.md): Generates a pivot table from an existing table based on specified criteria.
- [Create a Sample Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-sample-table.md): Creates a sample table with predefined data.
- [Create a Table from JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-json.md): Creates a table from JSON input.
- [Create a Table from the Rows](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-the-rows.md): Creates a table from one or more rows.
- [Create an Integer Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-an-integer-table.md): Creates an integer table with predefined columns and rows.
- [Get a Table from a File](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/get-a-table-from-a-file.md): Opens a table from a file, provided either through direct upload or at an S3 URL.
- [Cells](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/set-a-cell-in-a-table.md): Sets the value of a cell in a table.
- [Columns](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column.md): Retrieves a specified column from a table.
- [Cast a Table Column](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/cast-a-table-column.md): Converts a table column to a specified data type.
- [Column Formulas](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/column-formulas.md): Use column formulas to dynamically populate and transform column data in your tables.
- [Delete Table Columns](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/delete-table-columns.md): Deletes one or more specified columns from a table.
- [Get a Column Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-column-number.md): Gets the column number of a specified column in a table.
- [Get a Column's Values](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-columns-values.md): Gets the values of a specified column in a table.
- [Get Column Count](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-count.md): Retrieves the number of columns in the table.
- [Get Column Names](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-names.md): Retrieves a table's header.
- [Get Column Stats](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-stats.md): Calculates an aggregate value of a table column.
- [Insert a Column in a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/insert-a-column-in-a-table.md): Inserts a column into a table.
- [Move a Column](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/move-a-column.md): Moves a column in the table to a specified position.
- [Rename a Column](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-a-column.md): Renames a column in a table.
- [Rename Columns](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-columns.md): Renames columns in a table to new names specified by the user.
- [Round a Column's Values](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/round-a-columns-values.md): Rounds numeric values in a table column to a specified number of decimal places.
- [Update a Column in a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/update-a-column-in-a-table.md): Updates a column in a table.
- [Rows](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows.md): Retrieves a single row or multiple rows from a table.
- [Get Row Count](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-count.md): Retrieves the number of rows in the table.
- [Get Row Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-number.md): Retrieves the row number of the specified row in the table.
- [Get Value from Row](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-value-from-row.md): Retrieves the value of a specified column from the row.
- [Group Rows](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/group-rows.md): Groups the rows of a table by specified criteria.
- [Insert a Row](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-a-row.md): Inserts a row into the table with given data.
- [Insert an Empty Row](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-an-empty-row.md): Inserts an empty row into the table at the specified row number.
- [Remove Duplicate Rows](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/remove-duplicate-rows.md): Deletes duplicate rows from the table, optionally based on specified columns.
- [Set a Row to JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/set-a-row-to-json.md): Updates a row in the table using values from a JSON object.
- [Conversions](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv.md): Converts a table to a CSV formatted file.
- [Convert a Table to Excel](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-excel.md): Converts a table into an Excel file with customizable filename and worksheet name.
- [Convert a Table to JSON](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-json.md): Converts a table into JSON.
- [Convert a Table to Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-text.md): Converts a table into its text (string) representation.
- [Convert JSONs to Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-jsons-to-table.md): Converts a specified non-empty JSON array of objects (or single object) into a table.
- [Convert Thing to Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-thing-to-table.md): Converts a specified thing, such as a CSV file or JSON, into a table.
- [Manipulations](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table.md): Executes a SQL query on a table and returns the result.
- [Clear a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/clear-a-table.md): Clears all data from a table.
- [Combine Tables](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/combine-tables.md): Combines multiple tables into a single table based on specified criteria.
- [Copy a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/copy-a-table.md): Copies a table to a new table with a specified name.
- [Extract a Subtable from the Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/extract-a-subtable-from-the-table.md): Extracts a table from an existing table.
- [Group a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/group-a-table.md): Groups a table by a specified column and optionally aggregates other columns.
- [Join Subtables](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/join-subtables.md): Combines multiple subtables into a single table.
- [Replace Value in a Column](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-a-column.md): Replaces occurrences of a value in a table.
- [Replace Value in Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-table.md): Replaces occurrences of a value in a table.
- [Sort a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/sort-a-table.md): Sorts a table by one or more columns with optional ascending/descending order.
- [Split a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/split-a-table.md): Split a large table into smaller subtables.
- [Transpose a Table](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/transpose-a-table.md): Transposes a given table.
- [Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text.md): Learn how to manipulate text in your automations.
- [Boolean Checks](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/boolean-checks.md): Automation procedures for evaluating text conditions that yield either a "true" or "false" result.
- [Check Regex Match](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/boolean-checks/check-regex-match.md): Check if a text matches a regular expression pattern.
- [Check Text Contents](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-contents.md): Check if a value is present within a text.
- [Check Text End](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-end.md): Check if a text ends with another text value.
- [Check Text Start](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-start.md): Check if a text is started by another text value.
- [Conversions](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions.md): Automation procedures that transform text from one format or structure to another.
- [Convert a Character to a Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/convert-a-character-to-a-number.md): Convert a character into its corresponding numeric ASCII value.
- [Convert a Number to a Character](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/convert-a-number-to-a-character.md): Convert a number into its corresponding character ASCII value.
- [Convert Text Date to ISO Format](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/convert-text-date-to-iso-format.md): Convert a given text date to ISO-8601 format.
- [Convert Text to HTML](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-html.md): Create an HTML file by converting text to HTML.
- [Convert Text to Number](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-number.md): Convert a text representation of a number into its numeric value.
- [Get Lowercase Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/get-lowercase-text.md): Convert a given text to lowercase format.
- [Get Titlecase Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/get-titlecase-text.md): Convert a given text to title case.
- [Get Uppercase Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/conversions/get-uppercase-text.md): Convert a given text to uppercase.
- [Removal](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/removal.md): Automation procedures involving text removal.
- [Remove Text Using Regex](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-regex.md): Removes occurrences of a specified regular expression from a text.
- [Remove Text Using Substrings](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-substrings.md): Removes a specific piece of text from a larger text.
- [Combine Texts with Separator](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/combine-texts-with-separator.md): Combine a list of text values using a specified separator.
- [Extract Elements from Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/extract-elements-from-text.md): Extract lines, words, characters, URLs, numbers, or patterns from a text.
- [Extract Markdown Headings](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/extract-markdown-headings.md): Extract headings from a given markdown text.
- [Get Text Length](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/get-text-length.md): Get the length of a text string.
- [Replace Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/replace-text.md): Replace a text with another text.
- [Split Text](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/text/split-text.md): Split a text into smaller texts.