2021.2

fields that contain promotional data is the same in each record. These data are stored on the
root level of the extracted record.
Transactional data , on the other hand, are used in communications about transactions
between a company and their customers or suppliers: invoices, statements, and purchase
orders, for example. Naturally these data differ per customer. They are stored in detail tables in
the extracted record. The number of detail lines in a detail table can vary from record to record.
(For more information about detail tables, multiple detail tables and nested detail tables, see
"Detail tables" on page312.)
Detail tables are created when an Extract step is added within a Repeat step. The Repeat step
goes through a number of lines or nodes. An Extract step within that loop extracts data from
each line or node.
How exactly this loop is constructed depends on the type of source data.
Note that such loops work well when the data are structured uniformly, e.g. when all rows have
the same number of columns, and when detail data always start at the same point in the line.
Obviously, that is not always the case.
How to extract transactional data that is structured differently is explained in another topic:
Page 239