sort multi value field

[kfoudhaily]

I have a mutivalue fied

is there a way to sort in load script the values inside this field?

[sunny_talwar]

Sure, you can use Concat(..., ',', <SortingFieldHere>)

[kfoudhaily]

Thank you for your reply,

But I haven't concatenated my self the field, I got it that way from sorce

I need to unconcatenate it first to be able to use this expression.

regards,

[sunny_talwar · Accepted solution]

In that case... may be do this in two steps

1) Use SubField to put them in different rows

2) Use Concat with sort to put them back in the same row