Table

Table of contents


Description

Tables are an ordered collection of rows and columns. They allow you to receive data from a file and save data to files in various formats, or work with data in memory without being bound to a file. Detailed work with tables is described in the article Table processing .

Creating a table

You can create a new table from the context menu Add action β†’ Tables β†’ table :

Or

Or use smart search .

The created table will be displayed in the static blocks panel:

Table settings

The main

Load from file

Take data for a table from a file;

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

Save table changes to file

The result of working with the table will be automatically saved to the linked file;

If you load data from a file, but did not enable the Save table changes to file setting, then for each thread its own local copy of the table will be created based on the specified file. Changes to the table within threads will not affect the linked file in any way.

If the Save table changes to file setting is enabled, then all threads will work with one copy of the table and all changes will be saved to the linked file.

Leave empty file

If all the data in the table runs out, should you leave an empty file or delete it.

Custom format

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

If a ready-made file format is selected, then you can select additional settings for working with these formats:

First row headers

Use the first row of the table for headers;

Correct display of non-latin letters in Excel for .csv files

Parse data type (if possible)

Determine the data type in the content;

Separator for .csv format

Select he separator character β€œ;β€œ or β€œ,β€œ

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

Β 

Line Separator

Specifies what should be used to separate table rows. As a separator, you can use β€œEnterβ€œ, any of your own separators or several separators.

Column Separator

Specifies what should be used to separate the table columns. As a separator, the character ";", the tabulation character "Tab", any of your own separators or several separators can be used.

File path

If you have selected to load a table from a file, you must specify the path to the table file. Data from it is loaded into the table at the start of the project.

If the path to the file is not known in advance and will be calculated only during the execution of the project, then you can use the Table processing action and its Bind to file function.

View the content

Allows you to fully view the contents of the entire table. In this section, you can enable the display of control characters, set a filter to search for the desired string and cell, and also use the filter constructor.

Detailed work with a table is described in the article Table processing .

Β