Using Source Expressions

When importing data, you can apply source expressions to source dimensions. Source expressions can be used to enhance and transform the source value read from the file. For example, use a Rpad expression type to pad (add extra characters) to the right of a source dimension value to ensure a specific length.

For an "Amount" source dimension, the following source expression types are available:

• Fill: See Converting from European to U.S. Notation (Fill).
• DRCRSplit: See Displaying Debit and Credit Columns (DRCRSplit).
• Sign: See Using Nonstandard Numeric Sign Conventions (Sign).
• Factor: See Multiplying by Whole-Number and Decimal Factors (Factor).
• NZP: See Disabling Zero Suppression (NZP).

For information about applying source expressions to the Amount dimension, see Using Source Expressions for the Amount Dimension.

The following source expression types are available for non-Amount source dimensions:

• Prefix
• Suffix
• Concat
• Substring
• Replace
• Default
• Rtrim
• Ltrim
• Rpad
• Lpad
• Constant
• Conditional
• Split

Note:

All Target Expressions except SQL are available for Source

Note all the Target Expressions except SQL are available for Source

To assign a source expression:

1. From the Data Integration home page, click to the right of the integration, and then select Map Dimensions.

2. From Import Format, select the name of the import format to use for the integration.

   You can also add a user defined import format name.

3. File-Based Sources Only. Optional: From Type, select the format of the file.

   For more information on file formats, see Creating the Dimension Maps.

4. In the mappings grid, select the source value to which to add a source expression by clicking to the right of the dimension, and then selecting Edit Source Expression.

5. From the Edit Source Expression screen, click Expression Type, and then select a source expression.

   Note:

   The source expression types that can be applied to the Amount dimension include: Fill, DRCRSplit, Sign, Factor, and NZP. Multiple source expressions can also be applied to the Amount dimension. The Amount dimension does not accept Constant, Lpad, and Rpad expression types.

6. From the Edit Source Expression screen, select all parameters associated with the source expression, and click OK.

   The parameters shown on the page depend on the expression type.

   To remove a source expression type, click .