SourceFileName

We can instruct DecaSIM where to find pricing and product information based on the data in the source file.

Syntax:

The base syntax for this configuration is as follows. When a row is processed in the source file, we take the value that is in the field specified by ‘Source FieldName’ and split that value into distinct words (space delimited). We then take the element specified by the ‘element number’ in the configuration and that is put in the final file name at the position specified by ‘Position in Final File Name’.

Source Field; element number; SourceFileName.Position in Final File Name

Example:

FILE_SOURCE_PREFIX;0;SourceFileName.1
FILE_SOURCE_PREFIX;1;SourceFileName.3
FILE_SOURCE_PREFIX;2;SourceFileName.4
COUNTRY_CODE;0;SourceFileName.2
SOURCE_TYPE;0;SourceFileName.5

In this example we construct a SourceFileName with five data elements from the source file. The first 3 elements come from the field: FILE_SOURCE_PREFIX, the 4th element comes from the COUNTRY_CODE field and the final element comes from the SOURCE_TYPE field.

SourceFileName =   FILE_SOURCE_PREFIX[0] + FILE_SOURCE_PREFIX[1] + FILE_SOURCE_PREFIX[2] + COUNTRY_CODE[0] + SOURCE_TYPE[0]

See Also:

Prerequisites:

None