LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Table from the Rows
    • Create a Combined Table
    • Create a Merged Table
    • Get a Table from a File
  • Rows
    • Get Row(s)
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Group Rows
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Group a Table
    • Query a Table
    • Sort a Table
    • Split a Table
    • Join Subtables
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Enhanced Capabilities in the Latest Table Procedures
  • Example

Was this helpful?

Export as PDF
  1. Getting Started

Tables Overview

Learn to work with tables and tabular data.

Tables (v2) refers to the latest version of table procedures in Kognitos, offering improved performance and expanded capabilities. These are currently being rolled out progressively across agents. To learn more or request access, please contact our support team.

Overview

Table procedures in Kognitos provide a structured way to interact with tabular data, allowing users to read, modify, and analyze information efficiently. Tables are especially useful when working with lists, structured inputs, or datasets that require row-by-row operations.

Enhanced Capabilities in the Latest Table Procedures

  • Table Creation

  • Working with Table Rows

  • Working with Table Columns

  • Working with Table Cells

  • Converting Tables to CSV or Excel

  • Manipulating Tables

Example

Here's a simple example of using our Table (v2) procedures to process some documents:

Process Documents
create a table where
  the column names are "Document ID", "Document Type", "Status"
  
insert a row in the table where
  the Document ID is 721219
  the Document Type is "Invoice"
  the Status is "Pending"
  
insert a row in the table where
  the Document ID is 324236
  the Document Type is "Invoice"
  the Status is "Completed"

insert a row in the table where
  the Document ID is 384230
  the Document Type is "Summary"
  the Status is "Completed"

get the table's row where
  the row selection formula is "Status == Pending"

The procedures used in this example:

  • Lines 1-2: Create a Table

  • Lines 4-7, 9-12, 14-17: Insert a Row

  • Lines 19-20: Get Row(s)

Last updated 1 month ago

Was this helpful?