cancel
Showing results for 
Search instead for 
Did you mean: 

How to change target structure order

Former Member
0 Kudos

Hi Guys,

I am having the problem for changing the target structure order,

I am dealing the fixed length files using the sender file adopter I am getting the order what ever I want. example below mention.

created the data type message type and every thing my own and also used sender file adopter with file content conversion.

Source

STRU1

STRU2

STRU3

STRU1

Where as I got the XSD from the vendor for the target and used external definition. When I am doing the message mapping I am getting different order.

I want the target as below mention

Target

STRU1

STRU2

STRU3

STRU1

But I am getting as :

Target

STRU1

STRU1

STRU2

STRU3.

Can you guys please help to get order what ever I want....

Thank

Babu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI,

Plesae can you share the XSD file, as probably it will be helpful to analyse about the sequence of structure.

Thanks

Swarup

Former Member
0 Kudos

Guru's

Is any one can help to get work this kind of senario...

Thanks

M

Edited by: BABU P on Apr 1, 2008 10:42 PM

Former Member
0 Kudos

I don't think it's possible and I don't think this is the sense of XML messages. I suppose you work with XML structures, right? The mapping is doing the mapping for all STRU1 first, then STRU2 and so on. With XML you can never expect a certain order. In general, you should never make assumptions on the order of the output structures.

Former Member
0 Kudos

Babu:

I agree with the points from Jörg Thiesmann.

Unless you have context change, this seems to be impossible.

Liang

Former Member
0 Kudos

> I want the target as below mention

> Target

> STRU1

> STRU2

> STRU3

> STRU1

>

> But I am getting as :

> Target

> STRU1

> STRU1

> STRU2

> STRU3.

Set the context to "Source" of your source field which you are mapping to "STRU1". Just right click on your source STRU1 field and change the context.

Regards,

Sarvesh

Former Member
0 Kudos

Sarvesh,

Those are like STRU1, STRU2 STRU3 structures not fields, every structure has n number fileds.

When I configure my sender file adopter I got the order what ever i need, but when I am doing message mapping structure level mapping like

STRU1 -


> STRU1

STRU2 -


> STRU2

STRU3 -


> STRU3

Since STRU1 has 2 occurrences in source first and last.

when I did above mapping the STRU1 is comming 2 times as a first, Which I do not want.

I hope you understand ..

can you please help me how to get order in target..

Thanks

Babu

Satyagadadas
Active Participant
0 Kudos

Hi,

Use the record set sequence as ascending and use key field name and value

Former Member
0 Kudos

Hi,

Thanks for responding quickly,

Can you explain me how to do that in message mapping....

Thanks

babu