Mapping with index

[Former Member]

Hi experts:

I have a need to map based on index, but does not look like graphical mapsupports it. The input looks like:

<Data>

<ArrayOfString>

<string>ObjectId</string>

<string>Form_Type</string>

<string>Owner</string>

<string>CompletedDate</string>

<string>Delivered</string>

<string>Name</string>

</ArrayOfString>

</Data>

Depending on index of string, I need output as:

<List>

<formId>ObjectId</formId>

<GUIId>Owner</GUIId>

</List>

Is this achievable using Graphical maps?

-Feroz

[MichalKrawczyk · Accepted solution]

hi,

>>>Is this achievable using Graphical maps?

create an UDF which will take all the strings as input

and output only the first one and the third one

that's all

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Yeah.. I agree with Micheal

You need to build and UDF function receive two parameters the index that you need and the value.

[Former Member]

Thanks for all responses. I went the XSLT route is it offered better flexibility.

[Former Member]

In addition to above options..

you can use "Java Mapping". You can sort data the way you want using java mapping.

Thanks.

Nilesh

[Former Member]

Hi Feroz,

You can try to use "Sort" and "SortbyKey" standard functions.

Regards

Ivan

Edited by: Jose Iván Reyes Arteaga on Jul 16, 2009 4:10 PM