Parameters

An element that holds an array of <Parameter> elements.

<Parameters>
<!-- Array of <Parameter> -->
...
</Parameters>

The execution parameters are either passed in at the time of execution or calculated through a formula. The value of the name attribute is passed in as command line option, param-values. (Optional, if the path to the source file to load is specified in the path attribute of the source element or calculated column formula do not reference execution parameters)

Example 1, a name attribute reference an execution parameter

Example 2, is an example of a calculated formula. The FILEPATH function takes in two parameters, the first is a reference to the first parameter (i.e. a file path), and the second is a regular expression that includes a match group. The first match group's value is what gets assigned to the parameter. FILEPATH function executes regex against the full file path (including the directory structure)

Example 3, is another example of a calculated formula. The FILENAME function takes in two parameters, the first is a reference to the first parameter (i.e. a file path), and the second is a regular expression that includes a match group. The first match group's value is what gets assigned to the parameter. FILENAME function applies the regex only to the name of the file (excluding the directory structure)

<Parameters>
<!-- Example 1 -->
<Parameter name="file_path" />
<!-- Example 2 -->
<Parameter name="lob"
formula="FILEPATH('@file_path', '^.*[\\/](.{3})[\\/].*xls')" />
<!-- Example 3 -->
<Parameter name="business_date" formula="FILENAME('@file_path',
'^.*_Transaction_Detail_Report_(\d{8})\.xls$|^TRDTRX-(\d{8})-\d{4}[ap]m.xls$')" />
</Parameters>