Controlling how case data is written
Case (respondent) data for questions in grids and loop can be stored in a flat format or in a hierarchical format. By default, repeated questions are defined as levels, which means that the case data is stored in a hierarchical format. If you want to store it in a flat format, put the expand keyword at the end of the loop specification in the metadata section of the interview script, as follows:
LoopName "Question text" loop
{
Loop control list
} fields
(
Questions
) expand;
See also