Version: 17.07
Supported Since: 17.07
CSV Column Updater processing element can be used to update a column at the position indicated by (zero-based) column
of the CSV payload by the given list of Strings.
The CSV payload is expected to be in the RFC 4180 standard format.
In order to use this processing element, you must first select the CSV Message dependency from the processor list when you are creating an empty Ultra project. If you have already created a project, you can add this dependency via Component Registry. From Tools menu, select Ultra Studio → Component Registry and from the Processors list, select the CSV Message dependency |
String Row * |
Basic |
New cell values for the column |
Column Index * |
Basic |
Zero-based index of the column to be updated |
Skip First Row * |
Basic |
If selected, first row will be ignored during the update. Default value is false |
In the following use case, the requirement is to read a CSV file from a NIO File Ingress Connector, update a column in the the CSV message payload and deliver the message to a backend service via NIO HTTP Egress Connector .