Activity - csvProjection

Activity Type: Transformation

Description

Project a column of a csv document based on the given index.

Example

<csvProjection name="csv">
 <csvInput from="dataStoreOutput"/>
  <columnNo>3</columnNo>
        <delimeter>;</delimeter>
 <columnOutput name="csvOutput"/>
 </csvProjection>

Specification

Element :

• Attribute name - unique name for the activity within the scope of a request.
• Element csvInput(required) - define the CSV input whose values will be projected. The values should be included in double quotes ("). If a value contains a double quote (") in its body then it should be replaced with a pair of double quotes ("").
• • Attribute from (optional) - name of the output from another activity which provides the value of this parameter.
• Element columnNo  - the column index whose rows will be projected.
• Element delimeter (optional)  - the delimeter that separates the values. It can be any single character except double quote(").  If not provided, then comma (,) is considered as the default delimeter.
• Element columnOutput (required) - output stream which produces the projected values.
  • Attribute name - name of this output stream.

Input and Output Types

• Input: csvInput - java.lang.String in a CSV format
• Output: columnOuput - java.lang.String

Data Resource Accessor

This activity can operate with any data resource accessor.

XML Schema

OGSA-DAI/schema/ogsadai/xsd/activities/csv_projection.xsd

Class

uk.org.ogsadai.activity.transform.CSVProjectionActivity

Client Toolkit Class

uk.org.ogsadai.client.toolkit.activity.transform.CSVProjection