How to update Nth Element of an array

Question

How to update Nth Element of an array

Priya Jha 896

HI,

Is it possible to update/replace the nth element of an array

input =[1,2,3,4]

Update 3rd element from 3 to 5

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

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-02-28T00:17:56.9033333+00:00

@Priya Jha Just checking in to see if the 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,642 Reputation points Microsoft Employee Moderator

2023-03-01T23:19:30.3233333+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,642 Reputation points Microsoft Employee Moderator

2023-02-28T00:17:56.9033333+00:00

@Priya Jha Just checking in to see if the 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,642 Reputation points Microsoft Employee Moderator

2023-03-01T23:19:30.3233333+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

User's image

{
    "name": "UpdateArray",
    "properties": {
        "activities": [
            {
                "name": "Set variable1",
                "type": "SetVariable",
                "dependsOn": [],
                "userProperties": [],
                "typeProperties": {
                    "variableName": "Inter",
                    "value": {
                        "value": "@take(pipeline().parameters.IA,int(pipeline().parameters.ElementNbr))",
                        "type": "Expression"
                    }
                }
            },
            {
                "name": "ForEach1",
                "type": "ForEach",
                "dependsOn": [
                    {
                        "activity": "Set variable1",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "userProperties": [],
                "typeProperties": {
                    "items": {
                        "value": "@variables('Inter')",
                        "type": "Expression"
                    },
                    "isSequential": true,
                    "activities": [
                        {
                            "name": "Append variable1",
                            "type": "AppendVariable",
                            "dependsOn": [],
                            "userProperties": [],
                            "typeProperties": {
                                "variableName": "Final",
                                "value": {
                                    "value": "@item()",
                                    "type": "Expression"
                                }
                            }
                        }
                    ]
                }
            },
            {
                "name": "Append variable2",
                "type": "AppendVariable",
                "dependsOn": [
                    {
                        "activity": "ForEach1",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "userProperties": [],
                "typeProperties": {
                    "variableName": "Final",
                    "value": {
                        "value": "@pipeline().parameters.IS",
                        "type": "Expression"
                    }
                }
            },
            {
                "name": "Set variable2",
                "type": "SetVariable",
                "dependsOn": [
                    {
                        "activity": "Append variable2",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "userProperties": [],
                "typeProperties": {
                    "variableName": "Inter",
                    "value": {
                        "value": "@skip(pipeline().parameters.IA,add(int(pipeline().parameters.ElementNbr),1))",
                        "type": "Expression"
                    }
                }
            },
            {
                "name": "ForEach2",
                "type": "ForEach",
                "dependsOn": [
                    {
                        "activity": "Set variable2",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "userProperties": [],
                "typeProperties": {
                    "items": {
                        "value": "@variables('Inter')",
                        "type": "Expression"
                    },
                    "isSequential": true,
                    "activities": [
                        {
                            "name": "Append variable1_copy1",
                            "type": "AppendVariable",
                            "dependsOn": [],
                            "userProperties": [],
                            "typeProperties": {
                                "variableName": "Final",
                                "value": {
                                    "value": "@item()",
                                    "type": "Expression"
                                }
                            }
                        }
                    ]
                }
            }
        ],
        "parameters": {
            "IA": {
                "type": "array",
                "defaultValue": [
                    1,
                    2,
                    3,
                    4,
                    5,
                    9
                ]
            },
            "IS": {
                "type": "string",
                "defaultValue": "6"
            },
            "ElementNbr": {
                "type": "string",
                "defaultValue": "3"
            }
        },
        "variables": {
            "Inter": {
                "type": "Array"
            },
            "Final": {
                "type": "Array"
            }
        },
        "annotations": []
    }
}

Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2023-02-22T14:51:47.15+00:00

@MartinJaffer-MSFT Is there any better way you can think rather than using 2 for loop activities. This is the best I can come up with :)
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2023-02-23T10:19:07.9966667+00:00

the below blog can help :

https://datasharkx.wordpress.com/2023/02/23/replace-nth-index-item-of-an-array-via-azure-data-factory-synapse-pipeline-through-regular-expressions/

Answer 2

Hi @Priya Jha ,

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

I would go with Nandan Hegdes solution if you are referring to regular pipeline expressions. In case if you are using Mapping data flows and would like to achieve your requirement then you can use MapIndex function in Expression builder.

Here is a sample: User's image

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.

Share via

How to update Nth Element of an array

2 answers

Your answer