In Azure Data Factory, I have a “Copy” activity that uses an XML source data set. The structure of the XML is

<root>
    <record>
        <column1>...</column1>
        <column2>...</column2>
    </record>
</root>

How can I add a column3 as a child of the <record> nodes? I am trying to do this in the “Source” tab of the “Copy” activity, which gives the option to add an “Additional column”. I’ve tried syntax like the following for the name of the additional column:

1. $['root']['record']['column3']
2. /root/record/column3
3. root/record/column3
4. …other variations

Everything I’ve tried does add a “column” to the XML, but it adds it as a sibling to the root node (I see this by previewing the data set). I need the new column to be a child of the record nodes. I’ve not found anything about this on the internet. Thanks!