Table of Contents

Search

  1. Preface
  2. Introduction
  3. Installation
  4. Design
  5. Operation

Flattening Options

Flattening Options

Options for controlling how data is packed into repeating fields can be specified with the IDTDefinition’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 within the repeating fields. This makes it possible to relate data from two repeating fields. For example, the
nth Company_Id
is related to the
nth Address
.
Flat-Remove-Identical
By default, identical values in a repeating field are kept, making it possible to relate data from two repeating fields. It requires the same number of repeats for all repeating groups.
With this option enabled duplicate values are removed, so each repeating group 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.

0 COMMENTS

We’d like to hear from you!