ProductCodeFileName

Instructs DecaSIM how to build the file name to use to search for product codes based on data in each row of 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 Field 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; ProductCodeFileName.Position in Final File Name

Instead of a Source Field users can also use the key word USE_VALUE and then specify the hard-coded value to use. For example, the configuration USE_VALUE;BD;ProductCodeFileName.5 tells DecaSIM to use the value BD as the 5th element when constructing the file name to use to retrieve and append product code information.

Example:

FILE_SOURCE_PREFIX;0;ProductCodeFileName.1
FILE_SOURCE_PREFIX;1;ProductCodeFileName.3
FILE_SOURCE_PREFIX;2;ProductCodeFileName.4
COUNTRY_CODE;0;ProductCodeFileName.2
SOURCE_TYPE;0;ProductCodeFileName.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.

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

See Also:

SourceFileName, PRODUCT_CODE_APPEND_FIELD

Prerequisites:

PRODUCT_CODE_APPEND_FIELD must be present in the config file.