Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SORT in PI

Hi XI Gurus,

I have a problem regarding sorting again. Is there any way I can use sort but the characters after an "_" will not be part of the sorting?

EX.

test_1.0

variable_5.5

test_0.5

variable_0.1

expected output should be

test_1.0

test_0.5

variable_5.5

variable_0.1

what's happening in my mapping is

test_0.5

test_1.0

variable_0.1

variable_5.5

w/c is very wrong when mapped to the target fields.

I tried using substring first before I sort but I get this

test_1.0

test_5.5

variable_0.5

variable_0.1

please help. much appreciated. thanks!

Former Member
Not what you were looking for? View more on this topic or Ask a question