Table

Tables

Tables are used to store data retrieved from websites or data during the execution of an automated script. Each column in a table has a specific data type.

---

Creating a Table

Before adding data to a table, you must first create columns. There are five data types available for columns:

1. Text - string values (e.g., names, descriptions)

2. Number - numerical values (e.g., prices, quantities)

3. Boolean - true or false values (e.g., status, conditions)

4. Array - a list of multiple values within a single column

5. Any - Can store any type of data dynamically

Once the columns are defined, you can start inserting data into the table

Inserting Data

You can insert data into a table using nodes that extract data from a website, such as:

• Text Extraction Node (for capturing text content)

• Attribute Extraction Node (for retrieving element properties like URLs, IDs, or attributes)

How to Insert Data Using These Nodes:

1. Click on the extraction node

2. Select the "Insert into Table" option

3. Choose a column to store the extracted data

This allows you to automate data collection and store information efficiently in the table

Exporting Data Example

The example below demonstrates exporting data from the "col1" column in a table using the data export node. The exported data is inserted into a file named "test"

Export Options:

• If the file already exists, the "Append" option is selected to add new data to the end of the file.

• The data is saved in table format (CSV) for easy processing and analysis.

This method that the extracted data is efficiently stored and can be used for further processing.

Example:

Every time you insert data into a table, the new data is added to the last row of the column

For example, when inserting data into a table like this:

name	age	address
Anna	16	ARS
Billy	25	BYD

The table will be updated as follows:

name	age	address
Anna	16	ARS
Billy	25	BYD
Haaland

Store Data as Arrays in the Process

[
    {
        "name": "Anna",
        "age": 16,
        "address": "ARS", 
    },
    {
        "name": "Billy",
        "age": 25,
        "address": "BYD", 
    },
    {
        "name": "Haaland"
    }
]

Export Table Data

To export a table as a file, you can choose to export the data in various formats, such as:

• JSON (JavaScript Object Notation) – Exports data in a structured JSON format, suitable for use in web applications, programming, or API communication.

• CSV (Comma-Separated Values) – Exports data in a format where values are separated by commas (,), making it ideal for use with Excel or data analysis software.

• Text (Plain Text) – Exports data as a plain text file, suitable for simple data storage or note-taking.