iNTERFACEWARE™ Inc.

Mapping Repeating Fields Using Table Groups

If you want to handle any number of repeats with minimal mapping, it is recommended that you use table groups. The main advantage that table groups have over other methods is that you only have to map the repeating field once, no matter how many times it repeats.

	For detailed information on the various methods for handling repeated fields, see Mapping Repeating Fields. Before starting, download this sample VMD file that you can use to perform the steps in this section.

This section shows you how to map repeating fields using a table group.

Consider the following message:

MSH|^~\&|MESA_ADT|XYZ_ADMITTING|MESA_IS|XYZ_HOSPITAL|||ADT^A04|101102|P|2.5||||||||
PID|||583020^^^^code1~546^^^^code2~76466||WHITE^CHARLES|||M||AI
PV1|1||AMIG^^^11111^^^AMIG||||28888^TYLER^THOMAS^^^DR~12838^ALLISON^JASON^^^DR~14233^SOARS^AVA^^^DR~12555^JOHNSON^JOHN^^^DR|18113^DOE, JOHN|18113^DOE, JOHN|

The PV1 segment contains a field for Attending Doctor that repeats four times:

PV1|1||AMIG^^^11111^^^AMIG||||28888^TYLER^THOMAS^^^DR~12838^ALLISON^JASON^^^DR~14233^SOARS^AVA^^^DR~12555^JOHNSON^JOHN^^^DR|18113^DOE, JOHN|18113^DOE, JOHN|

Before you can map the repeating fields using a table group, you must first set the repeat limit of the applicable field.