How to swap the elements of an array

Question

How to swap the elements of an array

Priya Jha 901

HI,

Is there any way to swap the elements of an array

input = [1,2,3,4,5,6]

swap 2nd index and 3rd index values

Output= [1,2,4,3,5,6]

KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-02-28T00:16:17.39+00:00

@Priya Jha Just checking in to see if any of the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-03-01T23:18:27.9433333+00:00

@Priya Jha We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

2 answers

Your answer

KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-02-28T00:16:17.39+00:00

@Priya Jha Just checking in to see if any of the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-03-01T23:18:27.9433333+00:00

@Priya Jha We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

Hi @Priya Jha ,

Thanks for using Microsoft Q&A forum and posting your query.

You can use mapping data flow expression builder to achieve your requirement. You can utilize combination of mapIndex function and map function as below:


mapIndex([1,2,3,4,5,6], iif(#index == 3, map([1,2,3,4,5,6], #item)[4], iif(#index == 4, map([1,2,3,4,5,6], #item)[3], #item)))

User's image

Hope this helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Nandan Hegde 36,716 MVP Volunteer Moderator

Hey,

Follow the below blog to swap using regular expressions :

https://datasharkx.wordpress.com/2023/02/24/swapping-two-array-elements-in-azure-data-factory-synapse-pipeline-via-regular-expressions/

this is based on your earlier ask:

https://learn.microsoft.com/en-us/answers/questions/1183224/how-to-update-nth-element-of-an-array

Share via

How to swap the elements of an array

2 answers

Your answer