You must configure the Repeating Delimiter Type property as Character or Hexadecimal before you can configure this property. An alert message warns you if you’re exporting repeating fields to a file format that supports only the first value. When you export to these formats, only the first value in a repeating field is exported. Set the Structure property of the selected Record node to Delimited Some file formats (such as DBF) can interpret only one value per field and do not support repeating fields. You can examine and set this property in the Visual Studio Properties window when you select a Record node (including a root Record node) in BizTalk Editor and you have:Ĭonfigured the Flat File Extension option for the Schema Editor Extensions property of the Schema node XSD PersistenceĪs the value of the repeating_delimiter attribute of the element/annotation/appInfo/recordInfo annotation element. Because the input data file contains a varying number of repeated fields in each. The export records menu is found by navigating to 'File > Export Records.' The export options presented to you during this process will be based on the current layout/table you are viewing. No value, resulting in no annotation being added to the XSD representation of the schema, and specifying that the child delimiter specified for the selected Record node will be used. In that case, wed want our data set to have this structure instead. First, ensure that you are viewing the correct layout where the repeating fields are found. This value is only allowed when the Repeating Delimiter Type property is set to None.Īny string of characters entered in the format indicated by your choice for the Repeating Delimiter Type property.

No value, resulting in no annotation being added to the XSD representation of the schema, and specifying that the child delimiter specified for the selected Record node will be used.

Use the Repeating Delimiter property to configure, on a per-record basis, the string used to delimit repeating fields in this record in instance data.

File structure repeating fields