Skip to main content
Skip table of contents

Complex From Generic


The Complex From Generic tool converts a simple record stream into a complex record stream. It is the opposite of the Complex To Generic tool The input can be one of two forms:

  • Multi-field. A set of text fields that are sequentially numbered starting at F1. The number of generic fields is equal to the number of fields in the largest concrete record. The tool simply looks for all fields starting with F from F1 up to the largest F[N] and consumes them all. The fields are sized to hold the largest of all simple records' fields for that position. Fields are of type textvar, or Unicode.

  • Delimited. A single text field named Generic is read that contains a CSV-style formatting of all fields of each concrete record.

Complex From Generic tool configuration parameters

The Complex From Generic tool has one set of configuration parameters in addition to the standard execution options:





The type of data being input from the record stream: Multiple field or Delimited text.


The complex schema definition file that defines the resulting complex record stream.


If Type is specified as Delimited text, specifies how fields that contain the separator, quote, or escape characters are treated. If set to Quote, the field value is surrounded by quotes, and quote characters in the field are doubled. If set to Escape, special characters are preceded by the specified escape character.

Escapement character

If Escapement is specified as Escape, specifies the character used instead of the quote to escape special characters (such as separators and the escape character itself) by preceding them with this character.

Quote character

If Escapement is specified as Quote, specifies the character that surrounds the data when it contains any special character such as a separator or quote character. 


If Type is specified as Delimited text, specifies the character used to separate field values.

Configure the Complex From Generic tool

To configure the Complex From Generic tool:

  1. Select the Complex From Generic tool, and then go to the Configuration tab.

  2. Specify a complex schema definition file as Schema.

  3. Specify the Type of data being input from the record stream: Multiple field or Delimited text.

If you are converting from:

Do this:

Multiple inputs fields representing the fields of all complex records.

Choose Multiple field.

A single delimited-format text field.

Choose Delimited text, and then specify how fields containing separator characters are formatted on input:

  • Choose Disambiguate with Quote, and specify the Quote character and a Separator.


  • Choose Disambiguate with Escape, and specify the Escape character and Separator.

  1. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.