2018.1

Task properties
General tab
l
Group: Use the drop-down to select into which group the KeySet is inserted, or in which
group the KeySet should be updated.
l
Key set: Displays a list of keys for the selected group.
l
Key: Displays the key name in the group.
l
Value: Enter a value for the key, which will be inserted in the KeySet. This value
can be dynamic, including data selections, metadata selections, variables and other
data.
l
Update: Check to update the key with new data. For the Update column to be
active, the Update base on option must be checked. Key values will only change in
the KeySet if the Update checkmark is checked for that key, otherwise it is left
unchanged.
l
Create Group and Key(s) if they don't exist: Check this option to force the creation of a
new group and/or keys, if they do not exist. This is useful for portability: if a configuration
with this task is sent to a new Workflow server that does not contain this group or is
missing keys, the task will create them automatically.
l
Update based on: Check this option to update an existing KeySet instead of creating a
new one. The value of the Condition field is used to filter the KeySets to only obtain one
or more. Here are some valid conditions:
l last_name = 'Jones'
l id = 237
l age IS NOT NULL
l last_name LIKE 'La%'
l province IN ('QC', 'ON', 'AB')
l
Add KeySet when condition is false: If the update condition above is false, a new
KeySet is added to the group. If unchecked, no data is changed in the repository.
l
Store the result ID in variable: Select a variable or Job Info in which an array of inserted
or updated IDs will be placed. The array of IDs in the form of [1, 2, 3, 4, 2443, 532, 5457,
...]
On Error Tab
For a description of the options on the On Error tab see "Using the On Error tab" on page82.
Page 300