ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (15.4.0) 15.3.0 15.2.0 15.1.0 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Read File Variables

Read File Variables icon

Reads workflow variables from a source file. Source files contain properties defined as key-value pairs (syntax property.key=property.value) with one property per line.

If a line is not correctly structured, the property is skipped. Using whitespaces in values is allowed at any position in the string, for example, 'key= value ' or 'key=va lue'. For more information about how source files are parsed, see the Java documentation on the Properties class.

If the source file contains duplicated keys, the task fails. In case the limit set in maxLines is exceeded or a property value cannot be converted to one of input data types, a warning is issued.

You can also specify which properties should be read from the source file along with a specific data type and format parameters (see xref:File variable strategy). Once the data is loaded, you can reuse the values across the workflow using the following syntax:

${ewfGetTaskVariable("task_name", "key")}

For more information about working with workflow variables, see Workflow Variables.

When using the Text File Writer step in your plan, it is necessary to change the default writer configuration and remove the string qualifier and string qualifier escape character as this causes problems when using the Read File Variables task.

Text File Writer error

Properties

Name Type Description Expression support

Source File

mandatory

Source file that the task should read. The default extension is ewfv.

none

Encoding

mandatory

Encoding used in the source file. The possible encodings are all encodings supported by the target Java platform. Some commonly used encodings are: ISO-8859-1, ISO-8859-2, and UTF-8.

none

Max Lines

optional

Maximum number of lines that the task reads from the source file. Default value: 1000.

none

File variable strategy

Name Type Description Expression support

Implementation

mandatory

Type of file variable strategy. Must be set to Read Property File.

none

Variables

Name Type Description Expression support

Name

mandatory

Name of the variable.

none

Type

mandatory

Defines how to read the variable value. Currently supported types are: STRING, INTEGER, LONG, FLOAT, DAY, DATETIME, BOOLEAN.

none

Data Format Parameters

optional

Default data format parameters for the correct formatting of data in the source file. For more information, see Data format parameters.

none

Data format parameters

Name Type Description Expression support

Array Separator

optional

Defines which character is used as the array separator.

none

Date Format Local

optional

Defines the locale for parsing non-numerical data (for example, short forms of months in dates, such as Sep 18, 1999). The value is the same as the value of the corresponding locale in Java (see Java locales).

none

Date Time Format

optional

Defines the format that should be used for processing DATETIME data. The template is based on SimpleDateFormat, which uses the Java convention.

none

Day Format

optional

Defines the format that should be used for processing DAY data. The template is based on SimpleDateFormat, which uses the Java convention.

none

Decimal Separator

optional

Defines which character is used as the decimal separator. Escaped string property.

none

False Value

optional

String value representing a logical false value in the given data. The comparison is not case sensitive.

none

Thousand Separator

optional

Defines the string that represents the thousands separator (used in numbers). A non-escaped character is expected.

Numbers do not need to contain this separator, but when the separator is present, it is processed (stripped) accordingly. Escaped string property.

Default value: ,.

none

True Value

optional

String value representing a logical true value in the given data. The comparison is not case sensitive.

none

Example

Sample
<?xml version='1.0' encoding='UTF-8'?>
<EwfTaskElement>
    <acceptMode>ALL_VALID</acceptMode>
    <executable maxLines="1000" encoding="UTF-8" className=.ataccama.adt.task.exec. sourceFile="variables.ewfv">
        <fileVariableStrategy className=.ataccama.adt.variables.read.>
            <variables>
                <variableMapping name="variable1" type="STRING">
                    <dataFormatParameters falseValue="false" dateTimeFormat="yy-MM-dd HH:mm:ss" decimalSeparator="." dayFormat="yy-MM-dd" trueValue="true" dateFormatLocale="en_US" thousandsSeparator=""/>
                </variableMapping>
                <variableMapping name="variable2" type="STRING">
                    <dataFormatParameters falseValue="false" dateTimeFormat="yy-MM-dd HH:mm:ss" decimalSeparator="." dayFormat="yy-MM-dd" trueValue="true" dateFormatLocale="en_US" thousandsSeparator=""/>
                </variableMapping>
            </variables>
        </fileVariableStrategy>
    </executable>
    <id>read_variable</id>
    <priority>0</priority>
</EwfTaskElement>

Was this page useful?