ActionStep: Merge tables

Merges each selected row of one table to each selected row of the other table.

Where you can use action:
Workflow, Button

Parameters:
Source section 1 (type:text) - name of first table, which you want merge
Filter column 1 (type:text) - column address of first table, which will define rows, which have to be merged (column have to be in type: logical value)
Source section 2 (type:text)(optional parameter) - name of second table, which you want merge
Filter column 2 (type:text)(optional parameter) - column address of second table, which will define rows, which have to be merged (column have to be in type: logical value)
Target section (type:text) - name of table, which contains data merged from source tables (table cells must be editable and it must be turn on "Allow add rows" option)

Remarks: Action merges tables based on headers of columns, so headers of tables columns must be the same as headers in target table. If one header from source table doesn't exist in target table, data from column with this header won't be taken. If the same header is in both source tables and it matches header from target table, only data from one source table will be included in the result table. Cell types of the tables must be compatible with each other.

Example:

mceclip3.pngmceclip4.png

Result:

mceclip5.png

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk