| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Please read the Terms of Use for Materials on ZennoLab |
Table of contents
| Expand | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
...
Tables are used to obtain more complexly organized data than lists (for example, a list of products for an online store, where different data are presented line by line: name, price, description, etc.).
The action is used both when working with Tables and with Google Sheets, but Google Sheets has several unique actions, which are described in the article Google Sheets Operations.
...
How to add a table to a project?
| Info |
|---|
Before getting started, you need to create a Table or Google Sheets . |
...
How to add an action to a project?
...
Put the values of the given column into a list
...
We select the table with which we will work.
We indicate the function.
We set a column or variable.
A list into which we put all the column values.
| Expand | ||
|---|---|---|
| ||
Put all column B values from Table 1 into List 1  Table 1 Before processing  After processing  The specified column values are not removed after processing List 1  |
...
Get lines
Receiving a string with the ability to delete from the table and write to the list, variables.
...
We select the table with which we will work.
We indicate the function.
String criteria (you can specify a variable):
a) All
b) Does not contain text
c) Not matching regular expression
d) First
e) By numbers
f) Random
g) Contains text
h) Matching regexRemove after getting.
Place the result to a list or variables.
| Expand | ||
|---|---|---|
| ||
Take random rows from Table 1 and put into variables with deletion.  Table 1 Before processing  After processing  Variables  The variable peremennay_3 is empty because the table contains only columns A and B |
...
Put values from the list into the given column.
...
We select the table with which we will work.
We indicate the function.
We set a column or variable.
List with values.
| Expand | ||
|---|---|---|
| ||
Take values from list 1 and put in column D of table 1  List 1  Table 1 Before processing  After processing  Values are not removed from the list |
...
Add line
Add a line to the table.
...
We select the table with which we will work.
We indicate the function.
Insert static text or variable.
Important note
The line will be added to the end of the table
...
| Expand | ||
|---|---|---|
| ||
Add a line of your text to different columns.  Table 1 Before processing  After processing  |
...
Add text to a specific cell.
...
We select the table with which we will work.
We indicate the function.
We set static coordinates of the cell or through variables.
Insert static text or variable.
| Expand | ||
|---|---|---|
| ||
Add text and specified cell  Table 1 Before processing After processing  Lines are always appended to the end of the table |
...
How many columns does the table have
...
We select the table with which we will work.
We indicate the function.
The variable to get the result.
The variable will always contain only a digital value
| Expand | ||
|---|---|---|
| ||
Get the number of columns of Table 1 into a variable  Contents of Table 1 We get the result into the column_count variable  |
...
How many lines does the table contain
...
We select the table with which we will work.
We indicate the function.
The variable to get the result.
The variable will always contain only a digital value
| Expand | ||
|---|---|---|
| ||
Get the number of rows of Table 1 into a variable  Contents of Table 1 We get the result into the line_count variable  |
...
This action should be used when the file path is not known at the time of the template start and will be calculated only during project execution.
...
We select the table with which we will work.
We indicate the function.
Select a file or specify a variable containing the path to the file.
If the file is missing in the specified path, Zennoposter will automatically create it.
| Expand | ||
|---|---|---|
| ||
Bind table 1 to a given file  Table 1 will be linked to the corresponding file |
...
Get values from a given cell
...
We select the table with which we will work.
We indicate the function.
We set static coordinates of the cell or through variables.
Variable for the result.
| Expand | ||
|---|---|---|
| ||
Get into a variable the value from cell B2 of table 1  Table 1 content  After executing the action, we get the result into the yacheika variable  |
...
Sort table elements in descending or ascending order.
...
We select the table with which we will work.
We indicate the function.
Zennoposter will automatically detect the columns containing values and offer a choice.
Use the principle as for numbers (this option will work if the column contains only integer values. If there are fractional numbers, then the column will be sorted according to the principle of rows).
We set the type of sorting in descending or ascending order .
| Expand | ||
|---|---|---|
| ||
Sort in descending order the values of all columns of table 1  Table 1 Before processing  After processing  |
...
Saving a table to a file during project execution
...
We select the table with which we will work.
We indicate the function.
Select a file or specify a variable containing the path to the file.
| Note |
|---|
The function has the option to only overwrite the file |
| Expand | ||
|---|---|---|
| ||
Save table 1 values to a file  Table 1 content  After execution, all values will be written to the file  |
...
Removing duplicate values in tables
...
We select the table with which we will work.
We indicate the function.
Zennoposter will automatically detect the columns containing values and offer a choice.
| Expand | ||
|---|---|---|
| ||
Remove all takes in table 1  Table 1 Before processing  After processing  |
...
Removes the specified table column entirely
...
We select the table with which we will work.
We indicate the function.
We set a column or variable.
| Note |
|---|
The column will be deleted with all values |
| Expand | ||
|---|---|---|
| ||
Remove column B from table 1  Table 1 Before processing  After processing  |
...
Removes the given rows in all columns
...
We select the table with which we will work.
We indicate the function.
String criteria (you can specify a variable):
a) All
b) Not containing text
c) Not matching regex
d) First
e) By numbers (numbering from zero!)
f) Random
g) Containing text
h) Containing only space symbols
i) Matching regex
| Note |
|---|
The given row will be deleted in all columns |
| Expand | ||
|---|---|---|
| ||
Remove the third line from table 1  Table 1 Before processing  After processing  The third line has been deleted entirely |
...
Collect from the pages the name of the desired products in the list and add them from the list to the table for further use
...
Loading pages.
We collect the necessary values into a list.
We create a table.
Add an action and specify the function to add a list.
We indicate the list and the column in which we will save the values.
...