Help ith inputing data in file1 from file2 based on identical ID

Hi,

How do you modify the code below to input data in existing data element in file1 when both have identical NSN, code below adds a new record to file1 but I only need to copy the data from file2 to existing matching data elements in file1.

' Load the file1.xml and file2.xml into memory
        Dim f1 = XDocument.Load(Application.StartupPath + "\AOP40XYZ.xml")
        Dim f2 = XDocument.Load(Application.StartupPath + "\AOP40XYZA.xml")

        ' Query both documents and Join on the SN node in each 
        Dim results = From n1 In f1.Descendants("AOP40") _
                      Where n1.Element("NSN") IsNot Nothing _
                      From n2 In f2.Descendants("AOP40") _
                      Where n2.Element("NSN") IsNot Nothing AndAlso n1.Element("ID").Value = n2.Element("ID").Value _
                      Select n1, n2

        ' Copy the elements from File2 to File1
        For Each pair In results
            Dim removeSN = pair.n2.Element("SN")
            Dim removeID = pair.n2.Element("ID")
            removeSN.Remove()
            removeID.Remove()
            For Each element As XElement In pair.n2.Descendants()
                pair.n1.Add(element)
            Next
        Next

        '' Save the modified document
        f1.Save(Application.StartupPath + "\AOP40XYZFinal.xml")

Select allOpen in new window

Thanks,

Victor