# 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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.