You can specify one column name in the

Distribution Column

field to create multiple target files during run time. When you specify the column name, the Secure Agent creates multiple target files in the column based on the column values that you specify in

Distribution Column

.

Each target file name is appended with the

Distribution Column

value in the following format:

Each target file contains all the columns of the table including the column that you specify in the

Distribution Column

field.

For example, the name of the target file is

Region.csv

that contains the values North America and South America. The following target files are created based on the values in the

Distribution Column

field:

Region_North America.csv
Region_South America.csv

You cannot specify two column names in the

Distribution Column

field. If you specify a column name that is not present in target field column, the task fails.

When you specify a column that contains value with special characters in the

Distribution Column

field, the Secure Agent fails to create target file if the corresponding Operating System do not support the special characters.

For example, the Secure Agent fails to create target file if the column contains date value in the following format:

YYYY/MM/DD