none
Multiple records into a single record RRS feed

  • Question

  •  

    Hi

     

    In my mapping I have the following structure

     

    Source

     

    ctaLoop

    COM

    C076

    C07601

    C07602

     

    Destination

     

    E1EDPA1

    TELF1

    TELFX

     

     

    No I want to map the telephone number and the fax number to the detination Fields TELF1 and TELFX. The numbers n the source are in a loop of COM in the field C07601. The C07602 determines which  number it is (telephone or fax)

     

    Example for source

    <ns0:COM_2>
         <ns0:C076_2>
          <C07601>290 390</C07601>
          <C07602>TE</C07602>
         </ns0:C076_2>
        </ns0:COM_2>
        <ns0:COM_2>
         <ns0:C076_2>
          <C07601>290 391</C07601>
          <C07602>FX</C07602>
         </ns0:C076_2>
        </ns0:COM_2>

     

    Any ideas

    Friday, April 4, 2008 2:31 PM

Answers

  • You can use the = functoid, and the Value mapping(flattening) functoid.

    For output like:
    <ns0:E1EDPA1 xmlns:ns0="http://test.Schema2">
              <TELF1>290 390</TELF1>
              <TELFX>290 391</TELFX>
    </ns0:E1EDPA1>


    C07601 ----- = ---- > ---- TELF1
    C07602---------------

    Where = is the equal with TE as the 2nd argument
    and > is the value mapping flattening functoid.

    Sorry for the ASCII art... I can't find a way to post a screenshot.
    Monday, April 7, 2008 4:39 PM