Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Modify RowSet Task

Modify RowSet Task

The Modify RowSet task allows you to add, modify, or delete columns from a RowSet that was generated by tasks that read the contents of a file or database (for example, SQL or Read CSV tasks).
Field
Definition
Basic Tab
Label
Specify a label for this task.
Input RowSet Variable
Specify the name of a variable of type RowSet which contains the data to modify. For example, ${variableName}.
Output RowSet Variable
Specify the name of the variable that will contain the modified data. This will be a variable type of RowSet. If this variable exists it will be overwritten, otherwise it will be created.
Start With Existing Columns
Specify whether the output RowSet initially contains the column layout from the input RowSet (true), or if all new columns must be created (false).
Default Value: true
Exclude Row If
Specify a condition that will exclude a row if it is satisfied and prevent it from being included in the output variable.
Include Row If
Specify a condition that will include a row if it is satisfied and allow it to be included in the output variable.
Advanced Tab
Start At Row
Specify which row from the input RowSet should be the starting point for processing.
Maximum Rows
Specify the maximum number of rows that should be written to the output variable.
Control Tab
Version
The version of this task.
Log Level
Specify the level of logging to use while executing this task. Valid options are - silent, normal, verbose and debug.
Default Value: Inherited from parent Module
Execute Only If
Specify a condition that must be satisfied before this task can be executed. This task will be skipped if the specified condition is not met.
Disabled
Whether or not this task is disabled.
Default Value: false
On Error Tab
On Error
Specify the action to take when this task errors out. Valid options are - abort, continue, call:[module] and setVariable:[name]=[value]. For call:[module] replace [module] with the name of the module in the project (e.g. call:ErrorModule). For setVariable:[name]=[value] replace [name] with a variable name and [value] with the variable value (e.g. setVariable:error=true).
Default Value: Inherited from parent Module

0 COMMENTS

We’d like to hear from you!