How to sort rows based on field value

[former_member227811]

Dear  Experts,

How to sort rows based on field value.

regards

Abdul

[former_member186851 · Accepted solution]

Hello Mohd,

Try sortby key function which is under node functions.

If you can give example can assist you more.

[former_member227811 · Accepted solution]

thanks Raghu,

my scenario is in every row i have 5 fields.

Example:

Source

row : 1 to unbounded

field1

field2

field3

field4

field5

if value for field one is repeated (equal for 2 rows) then those 2 rows should come under one message at target and one message should be created for every value change in field1 at target.

hope this clarifies.

Regards

Mukheed

[former_member186851 · Accepted solution]

Mohd Try like Below

For Row Node

Field--->sort---->SplitByValue---->CollapseContexts-----Row

For Field Node

Field---->Sort------>SplitByvalue(For Value change)------->Field

[former_member182412 · Accepted solution]

Hi Mohd,

Try this mapping for root node of row and row node and field1 and field2 are direct mapping.

Test result

Remember this will only work if the same value occur immediately, if not this will not work you need to use sort function.

Regards,

Praveen.

[former_member186851 · Accepted solution]

Praveen I guess I told the same answer.

[former_member182412 · Accepted solution]

Hi Raghu,

Your row mapping and field1 mapping different, check again.

Regards,

Praveen.

[former_member186851 · Accepted solution]

Got it Praveen,

I believe the below should help him more

For Row Node

Field---Remove context--->sort---->SplitByValue---->CollapseContexts-----Row

For Field Node

Field--Remove context-->Sort------>SplitByvalue(For Value change)------->Field

[former_member227811 · Accepted solution]

Thanks Praveen and Raghu,

my requirement is same values are not immediate hence we need to sort and corresponding values for

field2

field3

field4

field5

should be same as in source structure.

Regards

Mukheed

[former_member186851 · Accepted solution]

Hello Mohd,

Try as Mentioned ..Sorted the values..

For Row Node

Field---Remove context--->sort---->SplitByValue---->CollapseContexts-----Row

For Field Node

Field--Remove context-->Sort------>SplitByvalue(For Value change)------->Field

It should wrk.

[former_member227811 · Accepted solution]

not working,

[Former Member · Accepted solution]

Field valueRows

This should work.

[former_member186851 · Accepted solution]

Hello Mohd,

Can you please post SAMple input and output XML.

[former_member182412 · Accepted solution]

Hi Mohd,

Use below mapping for Message and row and Field1:

All other fields:

Regards,

Praveen.

[former_member227811 · Accepted solution]

Thanks praveen,

Its working......

[former_member182412 · Accepted solution]

Hi Mohd,

Glad to hear that problem is resolved, close the thread as per this

Regards,

Praveen.

[asdasd_asdasd]

Using XSL mapping is the best option here.