Column Operations

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"