Row 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

Getting Number of Rows From a Table

get the first 10 rows of the table
get the first row of the table
get the last row of the table
get the third row of the table

Getting Specific Rows Based on Column Value

get the table's rows whose Pet Age contains "4"

This will return the following rows:

Setting Row Value To Something New

Once isolating some table rows, you can set all of the row's to a specific column value:

get the main table's rows whose Pet Age contains "4"
get the above as the cat rows

process each row as follows
  Set the row's "Pet Age" to "20"

Removing Specific Rows

Let's say based off a column value you want to remove some specific rows, you could write the following:

get the table's rows whose "COLUMN NAME" is empty
delete the above rows

Add an Empty Row to Table

add an empty row in the table