Creating Tables

Defining Table Headers

Let's say you are processing multiple documents and want to write the extracted fields to rows in a table. Kognitos allows you to easily create tables, starting by defining the column headers:

create a table where
    the headers are "{a column name}", "{a column name}", and "{a column name}"

Populating Table Rows

Once you have defined your table headers, add values for each row! To add a row, we need to define the values for each column in the row. To add values to the row, you'll specify which Column you want to add a value to.

It will look something like this, depending on your use case:

create a table where
	the headers are "VIN" and "Agency"

get the above table as the blank table

add a row to the blank table
	the row's VIN is "123"
 	the row's Agency is "ABC"

Setting Default Column Values

You can set a default value for all the rows of a column like this:

add "interests" as a column to the table where
  the default value is "singing"

Applying One Value to All Rows in a Column

If you want to set the same value for all the rows in a column, this is the syntax:

update the table's column whose name is "animals" where
  the complete column values are "birds"

Creating a Table from Another Table

Let's say you want to make a sub-table using only certain columns from one table, you can write:

create a secondary table from the table where
    the included columns are "COLUMN NAME 1", "COLUMN NAME 2", "COLUMN NAME 3"

You can change out the word secondary for a variable name of your choice, but once you run the above you now have a new table that you can refer to by the secondary table.