A group of actions: Tables
The action is designed to combine data from two tables.
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| First table | The table to which the data from the second table will be added. The results of the action will be stored in the current table. | Robin.DataTable | Yes | |
| Second table | The table whose data will be added to the first table. | Robin.DataTable | Yes | |
| Join type | The type of table join operation. | Robin.String | Yes | |
| The columns by which the tables will be merged. | A collection of condition strings for joining tables on the given columns. Where each line is a condition of the form: [column of the first table][operation][column of the second table]. Spaces are allowed between data. Instead of a column name, you can use its index, the numbering starts from 1. If we refer to a column by its name, then we select the name with curly braces: {column name}. List of valid operations: =, <>, >, <, >=, <= Collection string examples: {ID} = {UserID}, 1>{UserID}, 1 <> 5. | Robin.Collection | Yes | |
Обзор
Инструменты контента