Question:
How to work with table fields in a workflow?
Answer:
In the assign data activity, there are two options:
1. Destination Type: Table - Single column
When using this option the defined data will only be entered into one column, if the table doesn't contain any lines no data will be filled in, as it is not possible to create lines with this function.
In the assign data activity, there are two options:
1. Destination Type: Table - Single column
When using this option the defined data will only be entered into one column, if the table doesn't contain any lines no data will be filled in, as it is not possible to create lines with this function.
For this option, there are filters available. With this it is possible to define, based on already existing data, that only specific lines, should be filled with data.
2. Destination Type: Table - All columns
When using this, the whole table will be filled with data from another table. If the replacement check is not set the new rows will be appended, current lines are not touched.
Here you can choose which file cabinet and table the data should come from, then provide criteria which is used to find the right document / table.
In the second tab "columns" the columns from the existing table are assigned to the columns they should fill in the current table.
KBA applicable for both Cloud and On-premise Organizations.