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.

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)