Desktop User Guides > Professional > Data management scripting > Working with UNICOM Intelligence Interviewer - Server data > Expanding a loop from level to expanded
 
Expanding a loop from level to expanded
Loops are often created as levels for performance reasons, but they might need to be expanded during export to support the specific export type. To expand the loop, use the OnAfterMetaDataTransformation event.
Example
Event(OnAfterMetaDataTransformation, "Set the loop to expanded")
  Dim M2Q, MDM

  Set MDM = CreateObject("MDM.Document")
  MDM.Open(dmgrJob.TransformedOutputMetaData[0])
  MDM.Fields["Loop1"].Type = ArrayTypeConstants.mlExpand
  MDM.Save()
  
End Event
See
Working with UNICOM Intelligence Interviewer - Server data