Skip to Content
avatar image
Former Member

mapping structure

Hi, I have a problem solving this.

-E1PLOGI

-E1PITYP

-E1P0000

-E1P0001

-E1P0002

-E1P0003

-E1PLOGI

-E1PITYP

-E1P0000

-E1P0001

-E1P0002

-E1P0003

I want it to look like this instead:

-E1PLOGI

-E1PITYP

-E1P0000

-E1PITYP

-E1P0001

-E1PITYP

-E1P0002

-E1PITYP

-E1P0003

-E1PITYP

is it possible?

Edited by: Max Jonson on Oct 21, 2008 10:49 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 11:13 AM

    Is this your src ang tgt structure?

    Src

    E1PLOG1(0..n)

    -->E1P1TYP(0..n)

    -


    >E1P000(1..1)

    -


    >E1P001(1..1)

    -


    >E1P002(1..1)

    -


    >E1P003(1..1)

    Tgt

    E1PLOG1(0..n)

    -->E1P1TYP(0..n)

    -


    >E1P000(0..1)

    -


    >E1P001(0..1)

    -


    >E1P002(0..1)

    -


    >E1P003(0..1)

    Then the solution given by me is possible

    E1PLOG1--->E1PLOG1

    Duplicate E1P1TYP to 4 times on target

    E1P000>exists->createif--->E1P1TYPE(1st E1P1TYPE node on tgt)

    E1P000--->E1P000

    E1P001>exists->createif--->E1P1TYPE(2nd E1P1TYPE node on tgt)

    E1P001--->E1P001

    Reapeat this 4r E1P002 and E1P003

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 08:52 AM

    is this a static strcuture or bound to change

    i mean the struct E1P0001, 0002, 0003 only 3 struct or could be many 0004, 0005.... and u want the E1PITYP struct to appear ahead of every E1P000n

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 08:56 AM

    Try the below mapping

    E1P000-->EXISTS->Createif--->E1P1TYP

    E1P000--->E1P000

    Similarly do the mapping 4r E1P001,E1P002,E1P003

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, How can I mapp E1P000-- >EXISTS ->Createif--->E1P1TYP? I mean both E1P0000 and E1PITYP are in the right side of the mapping and they can not be mapped to eachother.

  • avatar image
    Former Member
    Oct 21, 2008 at 08:56 AM

    what is your source xml structure.....?

    provided structure is values or fields?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 09:37 AM

    What is your src and tgt struture?

    A better solution can be given.

    Add comment
    10|10000 characters needed characters exceeded