ADF, dataflow - sort in expression language

Question

I have an input string that was delimited by white space. In the expression builder I try using expression language to split it. Splitting works fine as array output [] but issues come out when input string is not a sequence number (red box). So, I need to sort the array value but I don't know how to use it.

The ideal condition is

1 2 3 4
1 3 4
1 4
2 4
4

but sometimes input string is not sequential number.

1 4 2
1 2 4 3
3 4 1 2
anyone can help me how to use sort the array value ?
What am I confuse is

Sort expects a reference to two consecutive elements in the expression function as #item1 and #item2.

What I expect the output looks like these below:

input | output
1 4 2 | 1 2 4
1 2 4 3 | 1 2 3 4
3 4 1 2 | 1 2 3 4

anyone can give an example for me ?

199026-sort.jpg

Answer 1

Hello @MasTidar ,

Thanks for the question and using MS Q&A platform.

Requirement:
What I expect the output looks like these below:
input | output
1 4 2 | 1 2 4
1 2 4 3 | 1 2 3 4
3 4 1 2 | 1 2 3 4

In order to achieve the above requirement, you can use below expression in your expression builder. This expression does split your input into an array and then sort the order and then replace the unwanted characters as needed.

replace((replace((replace((toString(sort(split(input, ' '), compare(#item1, #item2)))), '","', ' ')),'["','')),'"]','')   -> Please note that `input` is the source column name in this sample  

Below is the output for the expression:

Hope this will help. Let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators