Skip to Content
avatar image
Former Member

Challange with message split

Hi All.

I have to create a several files from one file according to the customer number

and I have to attach the right reference to the right customer positon number

let say I have the follwong file

<libarary>

<customer>

<pos>1</pos>

<nr>1</nr>

</customer>

<customer>

<pos>2</pos>

<nr>1</nr>

</customer>

<customer>

<pos>3</pos>

<nr>2</nr>

</customer>

<customer>

<pos>4</pos>

<nr>2</nr>

</customer>

<references>

<ref>1</ref>

<ref>2</ref>

<ref>3</ref>

<ref>4</ref>

</references>

</libarary>

according to the requirement I have to create 2 files , one for customer 1 and one for customer 2.

this is can be achieved by using split by value function to create 2 or more files , but my the challenge is how can I attache the ref field to the right pos field.

which means ref 1 and ref 2 should go to the file with pos 1 and pos 2 and ref 3 and ref 4 should go to the file with pos 3 and pos 4

the finale result should be like this

File 1

<File>

<customer>

<pos>1</pos>

<nr>1</nr>

</customer>

<customer>

<pos>2</pos>

<nr>1</nr>

</customer>

<references>

<ref>1</ref>

<ref>2</ref>

</references>

</File>

File 2

<File>

<customer>

<pos>3</pos>

<nr>2</nr>

</customer>

<customer>

<pos>4</pos>

<nr>2</nr>

</customer>

<references>

<ref>3</ref>

<ref>4</ref>

</references>

</File>

Any help will be higly apreciated

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 28, 2010 at 04:02 PM

    You have make sure all the levels properly mapped:

    libarary/customer/nr -> removeConext() ->splitByvalue[ValueChange] -> CollapsContext() -> File

    libarary/customer/nr -> removeConext() ->splitByvalue[ValueChange] -> customer

    libarary/customer/nr -> removeConext() ->splitByvalue[ValueChange] -> CollapsContext() -> SplitByvalue[each value] -> File/customer/references

    reference/ref----


    >

    FormatByExample() -> ref

    libarary/customer/nr -> removeConext ->splitByvalue[ValueChange]-->

    libarary/customer/nr -> File/customer/nr

    Liang

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Liang and Luis

      Problem solved with your help . thanks a lot

      I had thoug to change the

      libarary/customer/nr -> removeConext() ->splitByvalueValueChange -> CollapsContext() -> SplitByvalueeach value -> File/customer/references

      to

      libarary/customer/nr -> removeConext() ->splitByvalueValueChange -> File/customer/references

      Cheers and keep on the good work.

  • avatar image
    Former Member
    Sep 28, 2010 at 03:07 PM

    Hi.Merhej

    Try this

    Reference\ref -


    >

    -


    > formatByExample -


    >Target.

    Customer\r1-- >removeContext -


    >SplitByValue (ValueChange)>

    Luis Ortiz

    Add comment
    10|10000 characters needed characters exceeded