LogoLogo
About
Tables: v1
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v1
  • Tables
    • Overview
  • Creating Tables
  • Row Operations
  • Column Operations
  • Turning a Table Into an Excel File
  • Sorting Tables
  • Merging Two Tables Into a New Table
  • Using Values from Tables
Powered by GitBook
On this page
  • Example Table
  • Renaming Table Columns
  • Getting All the Columns From a Table
  • Adding Column/s within the Table
  • Deleting Column From Table
  • Getting Values From a Column
  • Getting Specific Column's Values By Name
  • Rearrange columns

Was this helpful?

Export as PDF

Column Operations

Last updated 1 month ago

Was this helpful?

Example Table

Pet Name
Pet Owner
Pet Age
Pet Type

Sokka

Christine

4

Cat

Momo

Christine

2

Cat

Zuko

Christine

4

Cat

Pablo

Jessica

6

Leopard Gecko

Scraps

Victor

13

Dog

Renaming Table Columns

Rename the table's "Pet Owner" column to "Owner"

Getting All the Columns From a Table

get the columns of the table 

Kognitos will return the names of the columns in the form of a list for you to use:

\

Adding Column/s within the Table

add "col1" as a column to the table

add "col2" as a column to the table where
  the column values are "1", "2", "3"

add a column to the table where
  the column name is "col3"
  the column values are "1", "2", "3"

Deleting Column From Table

delete the "Pet Owner" column from the table

Getting Values From a Column

First get the column of your choice, then get the values:

get the table's last column
get the column's values

When Kognitos returns values from a column, you can work with the data like a list of fields:

Getting Columns by Numeric Position

You can query different columns by its position:

get the table's first column
get the table's second column
get the table's third column
get the table's last column
etc....

Getting Specific Column's Values By Name

get the table's "Pet Name"

Rearrange columns

By default a table's columns are arranged alphabetically when extracted by Kognitos. This can be rearranged as per the user's necessity for the automation.

rearrange the table's columns where  
  the column headers are "City", "Address", "Number" and "Name"