MapExampleNestedTablesToFlatStructure

Use

In diesem Beispiel sind in der Ausgangsstruktur innerhalb eines Person -Rekords mehrere Telefonnummern dieser Person gespeichert. If you have to map this structure to a target structure where the telephone numbers that are stored in different, flat personnel records are for the same person, then you have to replicate the ID and Name fields from the source structure as many times as required.

Solution

  • There must be as many personnel records in the target message as there are telephone numbers. In this way, you assign the source field TelephoneNumber to the Person target field.

  • You replicate the ID and Name fields of the source message using the standard function useOneAsMany as many times as necessary. The target field mapping for the target field Name then looks as follows (the same as the ID target field):

    More information: useOneAsMany

  • Since the number of telephone numbers remains the same, simply assign the TelephoneNumber source field to the TelephoneNumber target field.