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 tableThe 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 tableThe table whose data will be added to the first table.Robin.DataTable
Yes
Join typeThe 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
  • Нет меток