Options for controlling how data is packed into repeating fields can be specified with the
IDT-Definition’s OPTION=
parameter:
Flat-Keep-Blanks
By default, blank fields are not moved into a repeating group. This option keeps blank fields, thereby maintaining positionality between the groups, allowing one to infer that, for example, the
nth Company_ Id
is related to the
nth Address
. This option requires the same number of repeats to be defined for all repeating groups.
Flat-Remove-Identical
By default, identical values in a repeating field are kept, maintaining positionality. With this option enabled, duplicate values are removed, so that each repeating field can be sized according to the number of unique values it is expected to hold. This option does not maintain positionality.
Removal of identical values only applies to the current IDT row under construction. If a repeating field overflows causing another IDT row to be created with the same key values, the values stored in the previous row are not considered when searching for duplicates.