Skip to main content

Table

Please read the Material Usage Rules on this site.

🔗 Original page — Source of this material

Description​

Tables are an ordered set of rows and columns. They allow you to get data from a file and save data to files in various formats, or work with data in memory without linking it to a file. Detailed instructions on how to work with tables can be found in the article ❗→ Table Operations.

Creating a Table​

You can create a new table from the context menu Add Action → Tables → table:

image-20200812-174916

Or

image-20200812-175008

Or use ❗→ smart search.

The created table will appear in the ❗→ static blocks panel:

image-20200812-175039

Table Settings​

Main​

image-20200812-175136

Load from file​

Get data for the table from a file;

Note

If you do NOT load the table from a file, each thread will have its own independent copy of the table.

Save table changes to file​

The results of your work with the table will be automatically saved to the linked file;

Note

If you load data from a file but do not enable the Save table changes to file option, then each thread will get its own local copy of the table based on the specified file. Any changes to the table within threads will not affect the linked file. If the Save table changes to file option is enabled, then all threads will work with the same copy of the table and all changes will be saved to the linked file.

Leave empty file​

When all the data in the table runs out, should an empty file be left or deleted.

Custom format​

You can use your own file format, or select one of the ready-made table formats.

image-20200812-175318

If a ready-made file format is selected, you can choose additional options for working with these formats:

First row as headers​

Use the first row of the table as headers;

Proper display of non-Latin characters in Excel for .csv files​
Parse data type (if possible)​

Determine the data type in the content;

Delimiter for .csv format​

Select the delimiter character “;“ or “,“

image-20200812-175448

Attention

Please note that when linking a table to .csv, .xls, .xlsx, .xlsm, .ods files, only the first sheet of the document is used

Row delimiter​

Specifies what should be used as a row separator in the table. The separator can be “Enter,” any custom delimiter, or several delimiters.

image-20200812-175545

Column delimiter​

Specifies what should be used as a column separator in the table. The separator can be a “;”, Tab character, any custom delimiter, or several delimiters.

image-20200812-175615

File path​

If you have chosen to load the table from a file, you need to specify the path to the table file. The data from it will be loaded into the table when the project starts.

image-20200812-175730

Note

If the file path is not known in advance and will only be determined during project execution, you can use the table actions and its Attach to file function.

View contents

Allows you to fully view the entire table contents. In this section, you can enable control character display, set a filter to search for the required row or cell, and also use the filter builder.

image-20200812-175804

image-20200812-175855

Detailed instructions on working with the table can be found in the article ❗→ Table Operations.